| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting numbers
result in cell = 445.987654 How do I copy just the remainder .987654 to
another cell, dropping the whole numbers? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formatting numbers
=mod(a1,1)
or =A1-int(a1) Asheret wrote: result in cell = 445.987654 How do I copy just the remainder .987654 to another cell, dropping the whole numbers? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formatting numbers
Put the following formula in the cell you would like the results in
Let's assume A1 is where the number 445.985343 is =a1 - int(a1) -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Asheret" wrote: result in cell = 445.987654 How do I copy just the remainder .987654 to another cell, dropping the whole numbers? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting numbers | Excel Discussion (Misc queries) | |||
| Formatting Numbers | New Users to Excel | |||
| Formatting numbers | Excel Discussion (Misc queries) | |||
| Formatting numbers | Excel Worksheet Functions | |||
| formatting numbers | Excel Worksheet Functions | |||
Hybrid Mode
