Excel and rounding numbers

  • Thread starter Thread starter Mosher
  • Start date Start date
M

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
 
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
 
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
 
Back
Top