Home |
Search |
Today's Posts |
#1
|
|||
|
|||
20 digit number
I need to put an invoice number with the following format: #### #### ## ########## I have to use just 1 celd. The problem is that Excel 2000 just takes the first 15 digits and truncates to 0 the rest. For instance: Number introduced: 12347890123478961234 Number showed: 1234 7890 12 3478900000 Can someone solve this? Thank you very much. Regards. -- belitre ------------------------------------------------------------------------ belitre's Profile: http://www.excelforum.com/member.php...fo&userid=8896 View this thread: http://www.excelforum.com/showthread...hreadid=380499 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering a number of more than 1 digit | Excel Discussion (Misc queries) | |||
How do I identify the 7th digit in a 13 digit number, then establi | Excel Worksheet Functions | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
spread the number 123.45 so each digit goes to a different cell | Excel Worksheet Functions | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |