First import your data as text, so A1 contains 0004

Then in B1 enter:
=LEFT(A1,2) & "." & RIGHT(A1,2) and copy down

--
Gary''s Student - gsnu200765


"ssetech" wrote:

when importing fixed width text file, all leading zeros are dropped. Is
there a way to add a decimal point to the beginning of a number?
i.e.
text file data = 0004
data = 0125
preferred outcome in excel
00.04
01.25
all custom formatting i have tried puts decimal to the left of number
any ideas
thanks