| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting decimals
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Splitting decimals
These formulas should do what you want...
A2: =TRUNC(A1) A3: =MOD(ABS(A1),1) Rick "Steve" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count digits before decimals and after decimals | Excel Worksheet Functions | |||
| Two decimals | Excel Programming | |||
| Numeric formatting: decimals and no decimals | Excel Programming | |||
| no decimals | Excel Discussion (Misc queries) | |||
| decimals only. | Excel Discussion (Misc queries) | |||
Linear Mode
