View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ssetech ssetech is offline
external usenet poster
 
Posts: 2
Default add decimal to beginning of number

i am importing fixed width text file but cannot get leading zeros to come
over and can't add decimal to left side of number when in excel.
i.e.
text file data = 0004
or = 0125
in excel i need to convert to
00.04
01.25
any ideas?
thank you.