Forum Discussion
Why Excel read "31/12/2022" as text instead of date?
Hi there, My Excel file reads one cell "31/12/2022" as text rather than date. This caused error in other cells with formula referencing to this file (should be read as date but it is text so re...
Hi Hans,
Thanks for your reply.
The dates in other cells are working well... that's the part puzzled me. Please find the screen shot below (the left column is the original dates I input and the right column is using formula "=xxx" so only that cell returns text).
Cheers,
Apparently, Excel interpreted the value as text when you entered it. There are several possible causes, but it's impossible for us to determine which one it actually was.