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
 

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
How do I keep Excel from dropping my numbers to 0 after 15 digits 1
Cell Number Format 1
I WANT TO WRITE 18 DIGITS FIGURE IN A SINGLE CELL. bu i m unable. 10
more than 15 numbers in a cell? 7
Maximum amount of numbers in one Cell 2
Date and Number cell formats 4
How to count the maximum number flanked by zeros 9

Back
Top