Forum Discussion
The Formatting got wrong!!!!!
Hey! Someeone please help me with this...
I have few data sets with me and both of them have dates coloumn in it. So I wanted to syncronize the dates from one sheet to another so I copied both in one sheet. Since is a daily data of 3 years its difficult tally them as the formatting of one sheet was different. So I want to change the formatting same as sheet 1 but the formatting fuction changes only selective cells which does not make any sense. Follow the image below....
Column B contains text values representing dates in US format mm/dd/yyyy.
Your system date format is probably dd/mm/yyyy.
Excel will convert a value such as 02/05/2025 (meaning the 5th of February) to a date, although not the correct one: it will become the 2nd of May.
But a value such as 02/13/2025 is not valid as a dd/mm/yyyy date, so it cannot be converted and will remain text.
If you import the column using Power Query, it will probably be converted correctly.
