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
24 mar 2022 · My formula under year is =YEAR(Date cell), but I not sure why the empty cell is showing as 1900? How to change the formula to show empty if there's no input in date? Thank you
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 gru 2013 · It will work if your dates are after 1st January 1900 (the zero point). Consequently if F5 =< 0 then display "". "" is standard notation for empty string of characters - so nothing gets displayed.
9 lut 2004 · Replacing 00/01/1900 dates with blanks Hi, In a column ‘A’ on Sheet1 I have a list of dates (in the format dd/mm/yyyy) and I am using the formula in column ‘A’ on Sheet2 e.g. =Sheet1!A2 copied down the column to populate the same dates, however, if a cell is empty on Sheet1 it will report the date 00/01/1900 in the corresponding cell in ...
9 kwi 2015 · 1/0/1900 error when cell blank, how to remove? Hi all, I have the following formula in my sheet and need to figure out how, if cells below are blank, to make this a zero number or no value or something so that it doesn't show 1/0/1900 date. the Formula: =MIN(L26:INDEX(L26:L10020, IFERROR(MATCH("Task Category 1", C26:C10020,0)-1, 9000))) I have ...
