How can I stop Excel from displaying rounded numbers? Credit car.

G

Guest

I read that Excel displays rounded numbers, though the actual values will
remain the same for calculations. I'm trying to simply input a credit card
number (16 digits), and it keeps rounding the last digit down to zero. I
can't figure out how to stop this from happening. Any one else know how to
prevent this?
 
J

Jason Morin

Either pre-format the cells as text prior to data entry
or precede each entry with an apostrophe ('). This will
ensure the credit card # is a text string, not a number.
Excel can only handle up to 15 digits precision.

HTH
Jason
Atlanta, GA
 
G

Guest

Precede the entry with an apostrophe ' (it won't be visible) or preformat
cell(s) as text
Excel has only 15 digit precision so credit card numbers will be truncated


Regards,

Peo Sjoblom
 
G

Gord Dibben

Excel has a 15 significant-digit limit.

Precede the numbers with an apostrophe to enter as text or pre-format the
cells as Text before entry.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Stop Excel from displaying rounded values 4
Excel is rounding numbers in ALL formats - how do I stop this? 5
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
How can I stop numbers from excel being rounded in a mail merge? 1
How do I stop Excel from dropping leading zeros? 9
How do you display 16 digit numbers in excel ? (it keeps convert. 3
How do I prevent Excel from putting 16 digit numbers into scienti. 2
How do I stop Excel from replacing "(c)" with copyright symbol? 2

Top