Why I have never discovered that until today!!!:
[=0]"";rrrr-mm-dd
"If there is 0, then do not put an erroneous date (a result of some bug in Excel insisting there is a 1900-01-00 date)". Is there more? Like coloring the font dependent on conditions met? Supercool!
Brak komentarzy:
Prześlij komentarz