| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Placeholder Values
I dont want to show place holder values that show were there are formulas but
the cells referenced by the formulas dont have values as yet. e.g cell G34 has formula: =SUM(F24:F33) and the referenced range has no values but G34 shows 0.00. The number format of G34 is NUMBER with a 1000 SEPARATOR to 2 DECIMAL PLACES. -- Wether you think you can or you think you cant , you are right ... anon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing zero values from a spreadsheet. | Excel Discussion (Misc queries) | |||
| "Show Placeholder" feature in options/view doesnt work | Excel Discussion (Misc queries) | |||
| Removing 0 or none 0 values from graphs | Charts and Charting in Excel | |||
| Removing Hidden But Keep Values | Excel Discussion (Misc queries) | |||
| Removing duplicate values in a column | Excel Worksheet Functions | |||
Threaded Mode
