This method can be applied to any special circumstance for bringing in a CSV file into Excel including other delimited files. With the ability of specifying the data type for each column during the data importing process you are in much better control on your final result.
In the first part, I ran through the basics on how to connect and configure your Mac Mini as the heart of your entertainment center. In this next article in the series, I had been planning on going into detail on how to store your media files on a remote NFS share. However, one of the comments on the first article got my attention and it occurred to me that I didn’t really cover alternate video codecs at all. So, rather than launch into some fascinating list of iptables rules and Apple alias quirks, let’s look at third-party codecs.
If your hard drive is short on space you might want to consider reducing the size of your Recycle Bin. By default Windows XP reserves 10% of your hard drive for the bin. You can save up to 3GB of space if you resize a bin to 1% on a 40GB hard drive. You can resize individual drive or all of them globally.
If you have an email you send out every day that contains the same information, or a form that requires users to dictate answers to the same questions – you can create a template in Outlook to help save you time.
Don’t you hate it when you are typing an email, a report, or chatting on IM and halfway through… you (or the person you are shouting at) realizes you have caps lock on?
The close tab buttons on each tab in Firefox 2 are really annoying. When you have a lot of tabs open, it becomes very difficult to click on the tab without accidentally clicking the close button instead.
If you have a lot of tabs open at a time, it’s sometimes quicker to have Ctrl+Tab switch to the most recent tab instead of the next one to the right. This is the default setting in the Tab Mix Plus extension for Firefox, so a lot of you are probably used to it.
My friend made the huge mistake of downloading PartyPoker onto a laptop from work - even after he uninstalled it, the menu item still showed up. He was worried about getting caught by the IT people, so he asked me how to get rid of it.