Unable to change date format in Excel

rznbyz - Sep 29, 2009 at 09:07 AM
 Tobby - Sep 6, 2019 at 08:43 AM
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

5 responses

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.

Thanks a lot man
This is a problem I have had for several months and TEXT to COLUMNS is the answer!! Thank you, thank you!