Techie help.

[deathpixie]

Is there a way in Microsoft Excel to switch numbers around en masse, without having to do it by hand? Specifically, dates - I have dates inputted as MO/DA/YEAR, but I've just been told it needs to be DA/MO/YEAR and I've got something like 500 dates to change. *whimpers*

Comments

[indiana-j.livejournal.com]

Are the dates all in one column/row or are they spread out? If they're all in one area, highlight that column/row and right click - you should be able to change the format to the way you want the dates to look that way.