|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 9th, 2005, 01:56 AM
|
|||
|
|||
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
April 9th, 2005, 03:02 AM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Missing Zero's when copying from XLS to CSV | lgardner | General Discussion | 1 | March 16th, 2005 11:42 AM |
| Number with leading zeros | SteveM | Worksheet Functions | 3 | February 2nd, 2004 04:47 PM |
| Leading Zero's | Tami | Worksheet Functions | 2 | November 24th, 2003 03:27 PM |
Linear Mode
