add decimal to beginning of number

  • Thread starter Thread starter ssetech
  • Start date Start date
S

ssetech

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.
 
Put 100 in an empty cell
edit|copy

Select the range to fix
edit|pastespecial|check divide.

Clean up the cell with 100 in it.

You'll want to give that range a nice custom format if you really want the
leading 0's.
 
Back
Top