I recently received a report filled with dates in Long Date format (Friday,
January 22, 2010). I would like to convert these dates into Short date
format but Excel will not let me. I do not know if this is a bug within
Excel. I have tried both Excel 2003 and 2007 with the same problem.
My regional settings is set to English (United States). I am not sure what
I am doing wrong? It does not seem that Excel allows the use of the long date
field even though you can take a short date and convert it to long date but
not the other way around.
Can someone please tell me if this is a limitation within Excel?