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.

[deathpixie]

Problem - it's not giving me da/mo/year as an option in the date listings. Closest I can get is 01-Mar-00, and I need all numerical. Is there a way to edit these things?

[deathpixie]

Wait, no, got it! Went into customise!

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

[trishalynn.livejournal.com]

I agree with the Custom thingie. Also, if you're allowed to surf the 'net at work, the techonogs at MS Office online help are surprisingly helpful and sometimes don't even work for Microsoft!