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.

add decimal to beginning of number
 

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.

ssetech wrote:

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.

--

Dave Peterson