Excel date format won't change

gto49 - Apr 14, 2010 at 10:06 AM
 Peaches - Oct 19, 2012 at 09:47 AM
If I enter a date into a cell in my Excel spreadsheet using the shortcut (CTRL+;), I can no longer change the formatting (right-click, format cell). The date format stays as entered... eg. 4/14/2010.

But if I manually enter the date, I can change the format, as long as it isn't entered in the format in the example. Just find this a bit frustrating...

Any help with this issue?

4 replies

Karl's solution is the one to go with!