![]() |
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. |
=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. |
All times are GMT +1. The time now is 08:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com