MAXIMUM NUMBERS IN CELL
 

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

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

--
Message posted via http://www.officekb.com