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

O

OldManP

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?
 
P

Peo Sjoblom

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

rounding problem need accuracy when using V Lookup 2
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Excel is rounding numbers in ALL formats - how do I stop this? 5
large numbers as text replaced with scientific notation 2
How can I stop numbers from excel being rounded in a mail merge? 1
How do I stop Excel from dropping leading zeros? 2
16 digit numbers 2
How to stop Excel from rounding up 2

Top