Céilidh | Cailey - My Life

Thursday, May 31

Excel Just Made my Day!

So I was trying to install Ultra-edit today (very unsuccessfully) in order to avoid having to add a comma to the end of 680 numbers in a long list.

Now i'm not one to avoid manual labour, but this mundane task just seemed unnecessary in the greater scheme of everyday life... so I sat for a minute (or two) and decided that there HAS to be a way of doing this in Excel.

After much trying (and failing) I finally stumbled upon a winner... ;)

Dum dee dum!

So here it is - for all the world to see:

Right click the highlighted cells --> Under the 'Number' tab choose 'Custom'
Then, where it says 'General' type '0\,'

HEY PRESTO!

I hope this makes your day as much as it made mine!