Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
17 digit number not inserted
I am totaling a number and the cell does not accept more than 15 digits.
Please help???? Thank you in advance Have a good day |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
17 digit number not inserted
hit44
XL can only recognize 15 digits as numbers, the only way XL can hold more is if it is the form of text. Either format the cell as text, or insert a single quote ' in front of your 17 digit entry. Does this help? Mike Rogers "hit44" wrote: I am totaling a number and the cell does not accept more than 15 digits. Please help???? Thank you in advance Have a good day |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
17 digit number not inserted
You say that you're *totaling* a number of more then 15 digits.
If this will be a common requirement of your procedures, then XL is *not* the program for you! Try something like Mathematica or Maxima. There are Add-Ins for XL that are supposed to enhance XL's ability to deal with numbers in excess of 15 digits. http://digilander.libero.it/foxes/index.htm -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "hit44" wrote in message ... I am totaling a number and the cell does not accept more than 15 digits. Please help???? Thank you in advance Have a good day |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create number format for 4 digit integer preceded by zero | Excel Worksheet Functions | |||
a number is replaced by text when inserted anywhere in the sheet | Excel Worksheet Functions | |||
"E" or "O" for the first, even or odd digit in a number | Excel Worksheet Functions | |||
How do I identify the 7th digit in a 13 digit number, then establi | Excel Worksheet Functions | |||
convert a nine digit number to base 32 | Excel Worksheet Functions |