Skip to main content

Posts

Showing posts from November, 2011

Changing to text in Excel

I find that I have to do this once in a while and every time I'll have to look it up again. Basically the problem is that someone sent an excel file which the column need to be a string but the data is numerical, so without adding the tick in front of the number, excel interprets it as number. Here's the small script to add the tick: For i = 2 to 196 Range("C" & i).Select ActiveCell.FormulaR1C1 = "'" & ActiveCell.Value Next Now I won't have to google all those mysterious command again the next time it happens.. p/s: don't laugh at me struggling with vb you insensitive clod.. :P

Back into Gnome 3

It has been quite a while since I've last used Gnome 3. The thing which I especially didn't like was starting an application by browsing the menu feels like a whole lot more cumbersome, mainly because it'll take the whole page filled with huge icons to do it and I didn't like how when you press alt-tab all the apps are grouped together kind of thing. So with a mind to get back to gnome 2, I switched my arch machine to use linux mint. But guess what? Even linux mint is moving to gnome 3 with it's upcoming release 12. Except it'll have a bunch of customization which keeps your workflow more the less the same. And not only that, it's even easy now to install the gnome-shell in ubuntu 11.10. So since now almost everyone is on that bandwagon, I might as well get on it myself. I've bought myself a spanking new laptop recently and thought that'd be a good candidate for a new start on gnome 3. At first I thought maybe I'll try fedora first (I've alwa