how to add decimal to beginning of imported number

[ssetech]

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

 

[Gary''s Student]

First import your data as text, so A1 contains 0004

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

 

[Marcelo]

if you need the result as number you can use:

assuming 0004 is on a1 on b1 use and 0125 on a2

=abs(a1)/100 copy it down

so excel will return 0.04 and 1.25

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"ssetech" escreveu: