Mar 20 2021 10:33 AM
Hello All,
I have a doubt. When i format date cell then i am not able to customize according to my need. Like it didn't change at all. Could you people help me so that it'll be more appreciable? I am also attaching workbook for which i need help And in that workbook cell under Subject the (Date) is not changed accordingly and in other cell it works fine. How this happen please help me to find ?
Thank you
Mar 20 2021 10:39 AM
That's since you have texts instead of actual dates. As variant select column, on ribbon Data->Text to Columns and on third step
after that apply proper date format to the result.
Mar 20 2021 12:23 PM
Thank you for your time. I was doing accordingly but it didn't work for me at all.
Kindly provide me feasible solution or macro so that i'll go through it.
Thank you
Mar 20 2021 04:00 PM
SolutionOkay, exactly for your sample file
1) Select part of the column with dates and Text to Columns
2) Select source date format and check that destination is correct
3) Click Finish
4) Press Ctrl+1 and select date format
5) Click Ok. Now you have texts as dates converted to dates
Please check file attached.
Mar 31 2021 11:35 PM
Apr 01 2021 02:38 AM
Excel Online has limited functionality and Text to Columns doesn't work such way in it. Alternatively you may use formula like
and apply to the result desired date format
Mar 20 2021 04:00 PM
SolutionOkay, exactly for your sample file
1) Select part of the column with dates and Text to Columns
2) Select source date format and check that destination is correct
3) Click Finish
4) Press Ctrl+1 and select date format
5) Click Ok. Now you have texts as dates converted to dates
Please check file attached.