Using text to colums, but need to keep decimals

M

mohagany19

I have a column of prices that I need to split into two columns, but
need to keep the decimal and leading zeros if applicable , fo
example:

102.46558
99.054
when split needs to be
102 .46558
99 .054

there will only be two or three digits in front of the decimal, bu
those ater it will vary.
This will save me two days of work if I can get this done
 
N

Norman Jones

Hi Mohagany,

Assuming your prices are in A1 down, in B1 enter

=Trunc(A1)

and in C1 enter

= A1 - B1

Drag the cells B1 and C1 down as far as you need.
 
Top