Cell Number Format

  • Thread starter Thread starter Ricardo Figueira da Silva
  • Start date Start date
R

Ricardo Figueira da Silva

Hi,
when i type for example this any number with more than 15
digits, the first 15 digits appear like i wrote it but the
rest of them are changed by zeros.

EX: i write this 123456789123456789
and the number that is kept is 123456789123456000

Does anyone experienced this and knows how to resolve it.

Thanks,
Ricardo
 
As you can verify in XL Help ("Specifications"), XL is limited to 15
decimal digits of precision for numbers.

If you're entering, say, a credit card number, which doesn't require any
math to be performed on it, you can preformat the cell as Text or prefix
the number with an apostrophe.
 

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

Why does Excel replace any digits beyond 15 with zeros? 2
Entering Large Number 8
How do I keep Excel from dropping my numbers to 0 after 15 digits 1
MAXIMUM NUMBERS IN CELL 1
Maximum amount of numbers in one Cell 2
Numeric Format Changes From 1 Cell to the Next? 2
Auto rounding of large numbers 2
Converting numbers formatted as text to numbers 1

Back
Top