| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numerical Breakdown
On Fri, 17 Jun 2005 12:14:27 -0500, Ron Coderre
wrote: For cell A1, these formulas return 1000's, 500's, 100's, 10's, and 1's respectively: =INT(A1/1000) =INT(MOD(A1,1000)/500) =INT(MOD(A1,500)/100) =INT(MOD(A1,100)/10) =MOD(A1,10) Does that help? Regards, Ron And simpler than mine. --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I resort numerical info into numerical order | Excel Worksheet Functions | |||
| best breakdown | Excel Worksheet Functions | |||
| breakdown months | Excel Discussion (Misc queries) | |||
| Breakdown | Excel Worksheet Functions | |||
| How 2 breakdown $$$ into $ $ $? | Excel Discussion (Misc queries) | |||
Threaded Mode
