| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I hide calculations/formulas?
I have created a worksheet for the purpose of date tracking. The problem
that I have is that 1/14/1900 is displayed after I create a formula. Example; the formula is a2=a1+14. When there is no date listed in a1 1/14/1900 is displayed. I do not want to see this. When I tried to hide this, I was unable to see anything. Is it possible to hide this particular problem? Thanks in advance for any help with this matter. |
|
#2
|
|||
|
|||
|
=if(isblank(a1),"",a1+14)
************ Anne Troy www.OfficeArticles.com "Xzilla" wrote in message ... I have created a worksheet for the purpose of date tracking. The problem that I have is that 1/14/1900 is displayed after I create a formula. Example; the formula is a2=a1+14. When there is no date listed in a1 1/14/1900 is displayed. I do not want to see this. When I tried to hide this, I was unable to see anything. Is it possible to hide this particular problem? Thanks in advance for any help with this matter. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Hide Column/s or Change Font color Only for printing | Excel Discussion (Misc queries) | |||
| hide a worksheet so that a macro can still find it | Excel Worksheet Functions | |||
| How Do I Hide A Row (if a condition is true) using a Macro ? | Excel Worksheet Functions | |||
| Hide AutoShapes On Excel Worksheet | Excel Worksheet Functions | |||
| Conditional Hide function for Excel | Excel Worksheet Functions | |||
Linear Mode
