Forum Discussion
Date formatting problem
Hi, I describe my problem: I digit a date (e.g. 26/11/2017) in a cell and Excel shows 43065. Any date format I apply to that cell, Excel always shows as 43065.
I use Excel 2016 for Mac.
Maurizio
Maurizio,
your date is probably text. Check it with ISTEXT() or ISNUMBER().
