MAXIMUM NUMBERS IN CELL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top