Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum amount of numbers in one Cell
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum amount of numbers in one Cell
Start the value with an apostrophe (single quote).
-- Gary''s Student - gsnu200907 "jas" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum amount of numbers in one Cell
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 -- HTH... Jim Thomlinson "jas" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set a maximum amount in a cell? | Excel Worksheet Functions | |||
Maximum amount allowed | Excel Discussion (Misc queries) | |||
What is the Maximum amount of sheets in a workbook? | Excel Discussion (Misc queries) | |||
formula that includes a maximum amount | Excel Worksheet Functions | |||
MAXIMUM NUMBERS IN CELL | New Users to Excel |