Thread: 20 digit number
View Single Post
  #1   Report Post  
belitre
 
Posts: n/a
Default 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