| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting and adding cells formatted to 2 decimal places
Is there any way that I can "Autosum" a column which has numbers formatted to
2 decimal places - were the "Autosum" adds the numbers as shown in the cell (not the numbers with full decimals). e.g. 1.2345 will show as 1.23 but when added includes the,0045 and shows an answer which does not add up according to the info displayed? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Global percentage decimal places default formatting | Excel Discussion (Misc queries) | |||
| conditonally formatting decimal places | Excel Discussion (Misc queries) | |||
| Help with formating cells (decimal places) | Excel Worksheet Functions | |||
| Can you set to default the # of decimal places in Format Cells? | Setting up and Configuration of Excel | |||
| Adding numbers in a column that have 3 decimal places | Excel Worksheet Functions | |||
Threaded Mode
