How to split numeric result of a formula in a cell into 2 cells?

D

Derek510

I have a formula for a cell, where the result will be numerical (123.5678). I
want to be able to split the results from that cell into 2 cells so that 123
is in one cell and .5678 is in the cell next to it so that separate formulas
can be made using the two separate data. I am using Excel 2003.
 
J

Jacob Skaria

Try this; but why not use the below formula in your other formulas and keep
the cell as it is...(You dont need to have 2 cells to carry this values)

A1 = 123.5678
B1=A1-MOD(A1,1)
C1=MOD(A1,1)
 
J

Jacob Skaria

Try this; but why not use the below formula in your other formulas and keep
the cell as it is...(You dont need to have 2 cells to carry this values)

A1 = 123.5678
B1=A1-MOD(A1,1)
C1=MOD(A1,1)
 

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

Splitting cell contents into 2 cells 1
Is there any way to split contents of a cell into more cells. 2
Split value into 2 cells 2
How to split number and text string to separate cells? 5
How to separate contents of one cell into multiple horizontal cell 1
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
Parsing line breaks into separate cells 3
How To Have A Cell Be Blank If... 2

Top