View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jhahes[_48_] jhahes[_48_] is offline
external usenet poster
 
Posts: 1
Default number length limit


I am putting a number in cell A1

the number is an order number that was generated
however when I put in the number, the last few digits are showing a
0's.

Is there any way to fix this, here is my number.

200603191216515085

and it is showing as

200603191216515000

Thanks for any hel

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=52505