how to add decimal to beginning of imported number
 

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

how to add decimal to beginning of imported number
 

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

how to add decimal to beginning of imported number
 

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:

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