Using text to colums, but need to keep decimals

  • Thread starter Thread starter mohagany19
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal 1
Zeros after the decimal 7
Fixed Decimals in Excel 2007 4
Spiltting numbers 8
Reducing Figures To Two Decimal Places 3
Formula for: Format Decimal places? 16
Merging Excel data to word, keeps including all decimals on number 2
Text to Colums 4

Back
Top