I’m sure you guys have seen this before when copy/pasting datasets into Excel (probably for the business?):
Well there is great format functionality in Excel 2010 (propably also in 2007) which I didn’t know:
Ok, first select the entire Excel-sheet by hitting CTRL-A.
After that….you’ve probably guessed it already…hit the AutoFix!
The result after:
That really saved me a lot of time 🙂