Forum Discussion
Jagdeep_
Sep 04, 2020Copper Contributor
Date Formatting
Dates shorter than or equal to 12 are right aligned.......rest are left aligned. When I am trying to change the format, it happens only for right aligned(Dates shorter than or equal to 12). Please h...
- Sep 04, 2020
I'd suggest select the column, Data->Text to Columns and on third step of the wizard select Date and MDY
Result is
Do that column by column
SergeiBaklan
Sep 04, 2020Diamond Contributor
I'd suggest select the column, Data->Text to Columns and on third step of the wizard select Date and MDY
Result is
Do that column by column
Jagdeep_
Sep 04, 2020Copper Contributor
SergeiBaklan Thank you Sir ! Thanks a lot......It's working. You made it so simple. Sir, I have one more doubt, Our system time format affects our excel date format ?