Cannot change the date format in Excel 2007 [Solved/Closed]

- May 17, 2010 at 09:16 AM - Latest reply:  Roja
- Feb 27, 2018 at 01:42 AM
Hello,

I have tried everything mentioned in this forum and they still do not work.

I have a sheet with the date appearing dd/mm/yyyy, I have tried Format Cells-Date-Type (mm/dd/yy) but it still stays in the format dd/mm/yyyy. I even went to Custom-Type(m/d/yyy) still nothing changes.

Any help please?

See more 

25 replies

Best answer
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- May 17, 2010 at 09:55 AM
110
Thank you
Because it is not a date to excel.

1. Select the column in which there was date
2. Goto data and choose text to column
3. choose delimited and click next
4. uncheck all and click next
5. click on date and choose right data format of the date that you currently have. It seems that you have DMY, Chose that and finish

This will transform the cells to date

Now format the date as you wish

Thank you, rizvisa1 110

Something to say? Add comment

CCM has helped 1664 users this month

Brilliant I almost feel like an expert now!
Thankyou so much :)
Thanks! Have had great problems with this issue in the past.
thank you...i tried this multi ways on the fast few days,..now i got cleared with your reference.