Cell Number Format

[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

 

[JE McGimpsey]

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.