View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default Numbers stored as text

Hi

000625 and 625 is the same number. What do you need the leading zeroes for?
Or, why do you need it to be a number?

Best wishes Harald


"prescottnana" wrote in message
...
Our accounting system exports to excel, problem is it sends numbers over
as
text. I can convert them easily to numbers, but then the next problem, it
drops all of my preceeding zeros. Example: our part number is 000625
convert
it to from text and it comes out 625. Any ideas?