Tuesday, August 28, 2007
Dealing With Unusual Date Formats
I’m sure that you have all been through this: You go to a Website (or a database, probably from a mainframe) to get some data. The problem is that the dates are formatted in some obscure way that Excel doesn’t understand. In this post, I’ll give you an idea of how to convert these dates into something that you can work with.
Yesterday I was working on a project that involves charting some economic data series. Frequently, charts of economic time series show shaded areas that indicate a period of recession (I’ve got a post that shows how to do that). So, I needed to know the dates for
Comments (2) • Permalink • Tell-a-Friend
Tuesday, August 07, 2007
Parallel Install of Office 2007 and Office 2003
I’ve been using Office 2007 for about a year now, but I had it installed on a PC that I built last year to experiment with the Vista and Office beta releases. I’ve since upgraded those beta versions to the full RTM (release to manufacturing) versions, but I don’t use that PC as my day-to-day machine. If you are like me, you may need to run both Office 2003 and Office 2007, and it is a real time saver to be able to do that without booting up another PC. The purpose of this post is how to run both versions on a single PC.
It is very simple, actually. Place the Office 2007 installation CD
Comments (6) • Permalink • Tell-a-Friend
