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?