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!