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

[dandesun.livejournal.com]

You should be able to highlight the cells you want to change, right click and change their format.

[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.

[redhawk.livejournal.com]

As many folks have mentioned - highlight your range, right-click, Format Cells. May have to go into Custom vs one of the canned formats but you can get it to D/M/Y vs M/D/Y.

Welcome to .us vs .rest_of_world date formatting. ;)