Search results
9 maj 2022 · =IF(C27=0,"",TEXT(C27,"YYYY")) should work - excel treats empty cells as equal to zero. So if it's equal to zero, this formula returns an empty string (""), which makes the cell look blank, if not then it returns TEXT(C27,"YYYY")
17 maj 2021 · Numbered items below in green are working just fine, items in red are what I'm having issues with: L7 has formula =N7-M7. However, I want for cells in that column to be blank when N7 and/or M7 are empty. Then, when user enters the values for N7 and M7, it provides calculated dates for L7 and J7.
7 mar 2022 · When the cell in sheet 2 is empty, "1/0/1900" is of course displayed in sheet 1. But I need to hide or suppress the "1/0/1900" until such time that an actual date is put into the cell in sheet 2. How do I do this?
11 lip 2019 · I have copied and pasted various times into an excel document, and changed the formatting to include the date. It defaults to 1/0/1900. I am doing this for many times and dates. How can I quickly fix the date without having to go into each cell?
Since the cells you are reading are blank, you get a value of 0, which is why the date shows as it does. To fix that, you can check the return for blanks, though I'm not sure why you are using INDEX/MATCH when VLOOKUP will work:
23 paź 2012 · However, if you the cell computes a date and you only want to display a blank, you could use a Custom format of the form: m/d/yyyy;;"" Alternatively, if you want the value to appear blank, you would need to change the formula (?) that generates the date.
26 wrz 2022 · The values 00/01/1900 aren't real blanks, but zeros. Does the Gas Expiry column contain formulas? If so, change the formulas to return "" instead of 0. Otherwise, select the column and replace 00/01/1900 with nothing (blank).
