Forum Discussion
Excel not converting date to text
Hello,
Since this morning we had a Microsoft update and for some reason, the date conversion to text is no long working:
I have a date field with the correct date in formation and we reformat the date to get the month and day as follows=
=TEXT([@Birthday];"DD-MM"). In files that are not modified, I get the correct information but as soon as I add a new row to the table, the whole column is changed to DD-MM. For some reason, if I include the year in the text function, I still get the year!.
I tried on a new workbook and have the same problem. Has anyone else noticed this?
3 Replies
Excel automatically applies formula to entire column of the structured table and recalculates it with any changes. If you are in automatic calculation mode. That's normal behaviour. Strange it didn't work before.
A "before" and "after" screen-shot might help me understand the problem better.
Hi,
Here is a screenshot of an example. I column D, I have a date field showing 21-Jan-24 and column E should convert the format to 21-Jan
If I make the change on Excel online, it works fine.
