| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Zeros when copying formular
I copied a formular down 10 cells for future input. The cells are all
showing 0.00, until I enter a value on the other side where the calculation will originate from. Can I hide those zeros and still have my formular intact. Thanks. /keith |
|
#2
|
|||
|
|||
|
Keith
You can turn off zeros in ToolsOptionsView. You could also use an IF formula to return a blank cell if a zero is present. =IF(A1 + B1=0,"",A1 + B1) Gord Dibben Excel MVP On Sat, 09 Apr 2005 00:56:28 GMT, "Keith Camacho" wrote: I copied a formular down 10 cells for future input. The cells are all showing 0.00, until I enter a value on the other side where the calculation will originate from. Can I hide those zeros and still have my formular intact. Thanks. /keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a cell to keep leading zeros. | New Users to Excel | |||
| Missing Zero's when copying from XLS to CSV | Excel Discussion (Misc queries) | |||
| Excel file saved as csv - dropping zeros | Excel Discussion (Misc queries) | |||
| Problems copying street addresses and dates | Excel Discussion (Misc queries) | |||
| Displaying leading zeros in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
