Forum Discussion
How to get a cell with a formula to ignore another cell with a formula that shows up blank
Hello. I am using a Custom Formula in Column B, C, G and H, to format how the date will show on an excel Gantt Chart. My aim is for Column B to calculate 5 days prior to what is in Column C (example...
Thanks, that is the formatting I have in place already. I think because it is a custom date setting it see it as a data entry, I am not sure. I know that if I ignore zeros on the sheet all the Jan 00 1900 disappear yet it still causes the B column to show hashtags.
That's odd. I'd have to see the sheet. You could try this one:
[<>0]mmm dd yyyy;[=0]""
- That was great for removing all the Jun 00 1900 from the Cells in Column C leaving blank, but still the respective Cells in Column B have the hashtags : (
Is there a way to post the sheet for you to view? I will gladly do so.- The ####### indicate the column is not wide enough to show contents OR an invalid cell formatting code is being used. You may not have the clearance level yet to attach workbooks, but you can do so if you message me.