| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I show only the whole number w/o eliminating four decimals?
I need to show only the whole number, not the number resulting by removing
the decimals. We do not want to force all of these cells. So, if the number is $104,978.6849 it needs to show $104,978, not $104,979 How do I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Negative number results to show as zero | Excel Discussion (Misc queries) | |||
| Displaying a number with different decimals depending on a condition | Excel Worksheet Functions | |||
| Specifying number of decimals in a number | Excel Discussion (Misc queries) | |||
| Force function to show positive or negative number? | Excel Worksheet Functions | |||
| Show week number in current month | Excel Discussion (Misc queries) | |||
Threaded Mode
