Search results
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
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")
Fixing date format 1/0/1900. Hey - Wondering why I'm getting 1/0/1900 for blank cells. I have done my normal Index Match formula that I do usually, and I've never seen this before. My usual formula is this - =IFERROR (INDEX (Target!$D:$D,MATCH (Commercial!$B4,Target!$C:$C,0)),"")
6 wrz 2005 · Column R of Sheet1 contains the formula =XLOOKUP(A2,data!$A$2:$A$100,data!$E$2:$E$100,"-") The result from a blank cell (in column E) on the data tab is "1/0/1900". I need this to display "-" in the cell if there cell on the data tab is blank.
10 cze 2010 · If the result of the vlookup statement is equal to zero then display an empty cell, otherwise display the results of the vlookup. If the cell containing the formula is formatted as a date the "" value will show up blank.
21 sty 2022 · Everything works fine except for a couple of rows. Excel is showing those as a 0 rather than a blank cell, so instead of giving me "No new date" as the output, it gives me a 1/0/1900. The format of the column is short date. If I change it to general, it shows a 0. How can I fix this?
24 mar 2022 · Hi. 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.
