Search results
9 maj 2022 · I have a spreadsheet that converts the date in one cell to a year in another. I want to pull the formula down so that it automatically shows the date in columns A and B if there is a date in column C; however, I do not want it to say 1900 on blank cells.
7 mar 2022 · I tried formatting the sheet 1 cell as a "custom" and used the following: "1/0/1900";"1/9/1900";;@...and that successfully hides/suppresses the 1/0/1900, but the issue is when an actual date is put into the sheet 2 cell, the date format is gone in sheet 1.
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
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?
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)),"")
20 wrz 2023 · H3 has formula =F3+7 (1 week), J3 has the formula =F3+14 (2 weeks) 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.
1/0/1900 dates in Excel can clutter your spreadsheet and make it difficult to work with. It is important to remove 1/0/1900 and blank rows to ensure data accuracy and integrity. Identifying and removing 1/0/1900 entries and blank rows can improve data analysis and visualization.
