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?
|