When entering more than 15 numbers in a cell, Exel automatically changes the
integers after 15 to a zero.
Example: 123456789123456789 entered into cell returns
123456789123456000.
Is there any way around this?
Thanx
Mangesh Yadav - 31 Mar 2005 05:14 GMT
Excel supports only 15 digits, but if you don't want to do any calculations
on these numbers, then you can enter them as strings. A preceding ' will
convert numbers to string. e.g.
'123456789123456789
is treated as a text string.
- Mangesh