by OldGuy » 05 Jan 2019, 21:17
Do you know anything about spreadsheet formulas and cell formatting? I have one column set up and formatted for dates. For example, If I enter just 1/5, it will automatically post 01/05/19. It works fine for every date in the year except 3.
If I put in 1/4 or 1/2, it will only post the fraction. I have to type in "Jan 2" or "Jan 4" for those two dates to format correctly, even though the cells are formatted for dates. Same thing happens for March 4. Entering just 3/4 always produces the fraction, instead of the date. Do you know how to fix that?
Do you know anything about spreadsheet formulas and cell formatting? I have one column set up and formatted for dates. For example, If I enter just 1/5, it will automatically post 01/05/19. It works fine for every date in the year except 3.
If I put in 1/4 or 1/2, it will only post the fraction. I have to type in "Jan 2" or "Jan 4" for those two dates to format correctly, even though the cells are formatted for dates. Same thing happens for March 4. Entering just 3/4 always produces the fraction, instead of the date. Do you know how to fix that?
