Maximum amount of numbers in one Cell

J

jas

Is there any way to change the maximum amount of numbers that you can put in
a particular cell. I have users that are using Excel for Tracking numbers
and some of them are greater than 15 digits. When these numbers are put into
Excel it puts 0's for every digit after 15 digits. Is there any way to
increase the amount of digits you can put in 1 particular cell?
 
J

Jim Thomlinson

If you require the number to remain a number for mathematical purposes then
there is not much that can be done. 15 significant digits is a limit of your
computer and not of XL. At that point scientific notation takes over.

If you only require text then either format the cells as text prior to
entering the number or preceed the number with an apostophe
'123456789123456789
 

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

Cell format - wrap text 7
Type 3 digits in one cell then automatically move to next cell. 4
Working with numbers in Excel-Specify # of digits 6
XL 2k - all digits in cell turn to 0 after 16th digit 1
Numbers in a column won't add up 1
How can I sort a list of numbers by the last 4 digits? 2
How do I stop Excel from dropping leading zeros? 9
Finding matching numbers from 1 worksheet in another and with a tw 1

Top