Splitting decimals

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I need to split a figure with a decimal value of 2 places, into 2 seperate
cells.

EG
I have a figure of 1.56 in cell a1
and I want to split it into
A2 and A3
A2 will hold the number before the decimal point and A3 will hold the number
after the decimal point.

Thanks
 
These formulas should do what you want...

A2: =TRUNC(A1)

A3: =MOD(ABS(A1),1)

Rick
 

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

UDF Function or Macro Needed 6
Thousand/Decimal seperator 3
Concatenate results without decimals 5
Open file and set numbers of decimal points 5
formula for decimal point 4
Number Format based on Cell Content 2
How to retrieve number of visible digits after decimal point in VBA 5
How can i split some symbol into many cells ? 2

Back
Top