| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
showing a rounded number without rounding it
how do i show a rounded number without rounding it
for example: i need to show a number $754,612 as $754,600, although i have to use $754,612 in the calculation. maybe there is a way to program a custom format, but i know know how. thank you! svetlana |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a Rounded number in a LOOKUP command | Excel Discussion (Misc queries) | |||
| how to display rounded number in a cell w/formula | Excel Discussion (Misc queries) | |||
| Number are rounded to thousand, but they now do not foot | Excel Discussion (Misc queries) | |||
| Can rounded numbers be summed without rounding errors? | Excel Discussion (Misc queries) | |||
| marrying a rounded number to concatenation. | New Users to Excel | |||
Threaded Mode
