Friday, November 25, 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

Saturday, November 19, 2011

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 always been unlucky with fedora for some reason). Since the new laptop already comes with Windows 7 and I wanted to dual boot anyway in case there might be situation where I might want to use windows, I wanted the installer to automatically resize the partition and install it side-by-side. But alas, my bad luck streak with fedora continues as trying to use the installer to resize the partition gives an error. I've forgotten exactly what the error was, but after 3 attempts at it, I said, well maybe I'll try something else. Burned an ubuntu cd and a few minutes later I've finished installing ubuntu 11.10 side-by-side with windows resizing the partition just using the installer. Sweeeeeeeet.. :) And one 'sudo apt-get install gnome-shell' and I'm in the game again. Oh, looked at unity a bit again first before installing gnome-shell, still don't quite like it.

One thing that I approach differently now when using gnome 3 is don't think so much of using it menus style, use it gnome-do style. Press the super key (that's windows key for those who don't know :) and just type a few letters of the app you want to start. Things I usually use like terminal and firefox usually come up right in front so it's really just pressing around 3 keys (super, f, enter). Apart from that I've wrapped my head around the idea of using the alt-tab and alt-"key above tab" for jumping between windows of the same app. So it's getting a whole lot more acceptable now. I might even convert my main desktop back to arch or something once I have the time. Starting to really like using gnome 3 again.

Haiya ala Solah