| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Currency sum not correct Excel 2003
Even though all currency values displayed are 2 decimals on my sheet, when I
use the formula function sum or subtotal to show the total of cells, it is displaying a rounded down amount and is 1 cent off because it is adding as if it knows there are actually 3 decimals in one of the cells even though only two are displayed. Can anyone tell me how to correct this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 compatibility | Excel Discussion (Misc queries) | |||
| Cannot Open Webpage With Excel 2003 | Excel Discussion (Misc queries) | |||
| Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
| Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
