Denver DataMan Blog

By: Steve | On: 9/24/2010

Denver DataMan in partnership with C Squared Computers has teamed up to honor three local businesses with the second annual Who's Your Hero Award.

This year the winners are:

By: Steve | On: 5/20/2008

I had the opportunity to present this Web Platform Showdown: Drupal vs. Joomla vs. Wordpress and want to share the slides on the blog. 

By: Steve | On: 11/30/2000

I found myself with forgetting how to easily reformat dates in Excel. The existing was in Excel and the dates like this “1943-08-24T00:00:00Z” I need the dates in DD/MM/YYYY format.

The first thing I tried was to use the left function to extract the first 10 characters which gets me the date.  However, for some reason, the left function would not let me change the output to the right date formula. 

Then a friend of mine suggested I try Excel Text to Columns.  Here is how you do that.

1.  Go to the Data tab 

Subscribe to Blog