| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
In Excel, how do you get it to not automatically round my dollars.
In Excel, how do you get it to not automatically round my dollars up or down.
Ex: I am summing a group of numbers and the total equals $598.6780. I want to show only 2 decimal places but do NOT want Excel to round the amount up. I want the answer to show me $598.67 not $598.68. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel automatically opens files | Excel Discussion (Misc queries) | |||
| Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
| Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions | |||
Threaded Mode
