| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Truncating numbers to show last three digits
=A1-ROUNDDOWN(A1,-1)
"Doug" wrote: I need to figure out how to have the numbers truncated as follows: $25.00 = $5.00 $22.00 = $2.00 $13.50 = $3.50 $10.00 = $0.00 -- Doug |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Truncating whole numbers - diplaying thousands instead of full num | Excel Discussion (Misc queries) | |||
| numbers truncating | Excel Discussion (Misc queries) | |||
| Combo Box - Show only first two digits? | Excel Discussion (Misc queries) | |||
| Truncating numbers | Excel Worksheet Functions | |||
| How do I shorten 10-digit # so only 6 digits show up? | Excel Discussion (Misc queries) | |||
Threaded Mode
