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 · Hi, You can change the format of the cells by going to Format Cells > Customs and adding following [=0] ;dd-mm-yyyy This will display a blank wherever the result is 0
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?
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:
20 wrz 2023 · If F3 is empty the following is shown in H3 and J3 07/01/00 and 14/01/00 respectively, but I want these cells to be blank when F3 is empty. Then, when someone enters a date in F3, it provides calculated dates for H3 & J3.
For a reason I can't find, my appropriate date of 12/31/16 in a date-defined cell shows as 1/0/1900. I have to put a single quote before for it to look correct, but then I have to treat it as text in formulas, or enter it as =date(2016,12,31).
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?
