Previous Topic Next Topic

Cannot change the date format in Excel 2007

Solved/Closed
Shayon - May 17, 2010 at 09:16 AM
 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?

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 17, 2010 at 09:55 AM
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
112
Entoor Dilipkumar
Feb 25, 2011 at 12:09 AM
Excellent, I happy about this forum. I sincerely thank rizvisa 1 for sharing this information.. It had helped me exactly.. Great...
-Entoor Dilipkumar
0
Steveo
Apr 27, 2011 at 09:19 PM
This is awesome - you saved me heaps of time with this !
0

Similar discussions

How to change the date format in Excel 2007
PANKAJ -
Praveen -

22 responses
Excel date format won't change
gto49 -
Peaches -

13 responses
Unable to change date format in Excel
rznbyz -
Tobby -

39 responses
How to change date format from yyyymmdd to mm/dd/yy in Excel?
lmw -
Sf -

12 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
converting number into words (Excel)
Bashir A.Zaroo -
GS -

6 responses