Small Excel Question Not Worth Its Own Thread

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us $3,400 per month for bandwidth bills alone, and since we don't believe in shoving popup ads to our registered users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware / Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread

Alkuan: Sep 8, 2006; Please hide me from those Berzerker's, they wont stop staring.

Hope someone can help me, i think this is a pretty basic thing to do but i'm rather lost.

I want to change a long list of data organized by mm/dd/yyyy to dd/mm and year by column. I have like 50 spreadsheets with 100 years worth of data by day in each one.

Starting like this:

1/1/2010 1
1/2/2010 4
1/3/2010 7
etc

So it would end up looking like this:

2010 2009 2008
1-Jan 1 2 3
2-Jan 4 5 6
3-Jan 7 8 9

Anyone know an easy way to do it?

# ¿ Aug 9, 2011 15:22

Adbot: ADBOT LOVES YOU

# ¿ May 23, 2013 14:04

The Something Awful Forums > Discussion > Serious Hardware / Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread