View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Numbers stored as text

hi
part numbers are ids. id numbesr are "numbers" that you don't want to do
mathmatical stuff to ie you don't want them to change. have you ever had a
reason to devide your phone number by 2????
so it would make no difference if the id was text or number?
what advantage do you gain by having your part numbers as numbers?

my thoughts
regards
FSt1

"prescottnana" wrote:

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?