Unable to change date format in Excel

Solved/Closed
rznbyz - Sep 29, 2009 at 09:07 AM
 Tobby - Sep 6, 2019 at 08:43 AM
Hello,
I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I double click in each individual cell and then move out of that cell the format changes and the dates appear correct. I have 24854 dates I need to change, I can't take time to double click in each cell. Any suggestions? Thanks
Related:

5 replies

This works:
  • First change your format to the specific date that you want for your column of data.
  • With the column selected, select "Copy"
  • Open notepad (NOT WORD, it has to be notepad)
  • Paste your data into notepad.
  • In notepad, press CTRL + A (selects all cells) then press CTRL + C (copies data)
  • Paste data back into Excel.
  • It will say something about size not being the same, paste it anyways.


That works.

-24
535
Thanks a lot man
0
this is the best answer, thanks
0
Thank u!!!
0
sweet work bro
0
i have change in formula bar cell format of date in excel 2003
0