| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to split numeric result of a formula in a cell into 2 cells?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to split numeric result of a formula in a cell into 2 cells?
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) -- If this post helps click Yes --------------- Jacob Skaria "Derek510" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to split numeric result of a formula in a cell into 2 cells?
=INT(A2)
=MOD(A2,1) -- David Biddulph Derek510 wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Bar F9 Result differs from cell result??? | Excel Worksheet Functions | |||
| split cells with each having a formula possible? | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Split the numbers in a alpha numeric case | Excel Discussion (Misc queries) | |||
| Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) | |||
Linear Mode
