Re: Excel Cell Format

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Mike --- You are 100% correct, I had forgot about that. My business days
have been over for sometime and my memory is not what is used to be, since I
retired a few years ago. Used to use Excel almost every day, now maybe once
or twice a month and that is just to kind of fool around so I don't forget
everything I used to know.
--
Larry D


"Mike G" wrote:

Just to add a note from the Excel Help file; "15-digit limit Regardless of
the number of digits displayed, Excel stores numbers with up to 15 digits of
precision. If a number contains more than 15 significant digits, Excel
converts the extra digits to zeros (0)." So it is not just because your CC
ends in a "9"....and number will do that.... Mike


"lfessler" <lfessler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:24A17AA4-A71E-436A-88E2-2AF30F7C2BF1@xxxxxxxxxxxxxxxx
Bob --- I understand your comments, I was just pointing our that I'm
comfortable with RoboForm and frankly my comments about "Rocket Science"
was
made as a result of my wife stating that is was easy for her to use and
for
my wife to make a statement like that is rather unusual.

I basically comfortable with Excel and have used it for years. Used to
use
it daily before I retired, but I'm a bit rusty now as I really don't have
many challenges for good spread sheets like I used to do. Also my memory
is
not what it used to be and I had forgot about the 15 digit rule, but as I
said I do use the ' apostrophe method.

Not to bore you, but my wife's computer (that she used to have) came with
Works 6.0 installed a few years back (three or four as I recall) and Works
Spread sheet does not have that restriction if my memory serves me
correctly.

In any event thank you for all of your comments and suggestions enjoyed
communicating with you.
--
Larry D


"Bob Phillips" wrote:

Larry,

It was Excel that I was saying was easy, not RoboForm. I don't know
RoboForm
well enough to know, but looking at the website, I assumed it would have
encryption of that sort of level.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"lfessler" <lfessler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2D00C28F-6436-45F9-AD9E-BAC958903769@xxxxxxxxxxxxxxxx
Bob --- The following is my answer from RoboForm support concerning
security.

""Your Identities and Passcards are encrypted using AES, BlowFish, RC6
or
3DES algorithm and the encryption / decryption key is generated from
the
Master Password. This encryption method makes your data very secure and
even
if hackers come into possession of your Identity and Passcard files,
they
will have to crack one of these encryption algorithm without knowing
the
key
which is considered impossible. By default AES encryption is used.""

I'm very comfortable with that response, and I like the way it
functions.
Very easy to use and it does not require a degree in "Rocket Science"
to
understand the operation.
--
Larry D


"Bob Phillips" wrote:



"lfessler" <lfessler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:18EE0963-CF5F-4142-812D-0BAC1B159286@xxxxxxxxxxxxxxxx
Bob ---- Thanks for both of your responses. I'm not familiar with
KeePass,
but will investigate it and see what the differences are between it
and
RoboForm.

I took a look at RoboForm, and the biggest difference is that KeePass
is
free. It seems that RoboForm has some extra functions for using tyhat
data
also.


I have used and do use the ' apostrophe solution, but was hoping
their
was
another way to format the cell so I could store longer numbers.

I don't think, just seems a limitation of Excel's arithmetic engine.

I hate to say this, but I do know that Excel is not necessiarly
secure
,
but
I have done everything humanly possible to protect the file and my
computer.
I'm what you would call a "SECURITY FREAK". Having said that I do
realize
that the best of the those folks our their who want to hurt you and
get
data
from you have many deviious ways to do so!!!!!!

Unfortunately with Excel you don't have to be the best or even
devious,
it
is EASY.









.

Relevant Pages

  • Re: Excel Cell Format
    ... Just to add a note from the Excel Help file; ... the number of digits displayed, Excel stores numbers with up to 15 digits of ... It was Excel that I was saying was easy, not RoboForm. ... 3DES algorithm and the encryption / decryption key is generated from ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Excel Cell Format
    ... It was Excel that I was saying was easy, not RoboForm. ... 3DES algorithm and the encryption / decryption key is generated from the ... I took a look at RoboForm, and the biggest difference is that KeePass is ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Excel Cell Format
    ... I basically comfortable with Excel and have used it for years. ... "Bob Phillips" wrote: ... It was Excel that I was saying was easy, not RoboForm. ... encryption of that sort of level. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Unacceptable floating point errors
    ... which Excel would display as 0.010...0 to 15 significant digits. ... But I do not mean to suggest that Excel is flawed for not doing so in its ... The exact internal representation of the constant 0.01 is ...
    (microsoft.public.excel.misc)
  • Re: INT defect: Please try this on 2007 for me
    ... Not that I would object to a calculation option that would do just that, namely: force the result of all formulas to be rounded to 15 significant digits, not unlike the "Precision as displayed" option, but more generally applied. ... That would legitimatize some of the heuristics that Excel has implemented to try to ameliorate the aberrations due to binary floating point arithmetic. ...
    (microsoft.public.excel.worksheet.functions)