Excel and rounding numbers

[Mosher]

Hi all,

I have a problem that is really driving me batty. I have created an Excel
spreadsheet where I keep track of sixteen character credit card numbers.
Excel is rounding the last digit up or down...and I can't turn it off. I
have gone into "tools/options/calculations" and selected "Precision as
displayed", and tried other formatting in the "format, cells"
section...nothing is working. Can anyone help me with this frustrating
problem? Why is this so difficult!!!

Thanks,

Mosher

 

[Peo Sjoblom]

Excel has only 15 digits precision that means that everything more than that
will be truncated,
however since they are credit card numbers you don't need to do calculations
with them and the you can
pre format the cells as text or when your type precede each entry with an
apostrophe

 

[Chip Pearson]

Mosher,

Format the cells as Text prior to entering the data, or precede
the data with an apostrophe.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Mosher]

Thanks to both of you - the formatting to text did it.

Mosher