This is a procedure that I often use to convert dates originating from mainframe downloads into an Excel readable format. The dates come across in the following eight character format -> “20040101” - (Jan. 1, 2004).

Sub StringToDate()
Dim d As Range
Dim r As Range
On Error Resume Next
For Each d In Range("A1:A10")
d.Value = Format(DateSerial(Mid(d, 1, 4), Mid(d, 5, 2), Mid(d, 7, 2)), "yyyy/mm/dd")
Next
End Sub

The macro would need to be modified using the Mid worksheet function to allow for differing string lengths.

1) Default setting is important: Most of the people leave the default unchanged.
2) Sales people should not dictate the site design.
3) Usability: Programmers should be asked to help 100 new users to register.

When Excel adds a date to a header or footer, the default appears in the “MM/DD/YY” format. You can change this formatting via the following example:

Sub Change_Format()
ActiveSheet.PageSetup.CenterHeader = Format(Now, "MMM DD, YYYY")
End Sub

Resatrting windows is often necessary after installing an application or making other changes. You can do this in Windows 95/98/ME by selecting Restart from the Shut Down Windows box, holding down the Shift key, and clicking Yes. This performs a warm restart, much faster than a complete reboot.

Google will send you email alerts when specific items are mentioned in the news or found on web sites. I have several alerts running. For example, I like to know when any Microsoft MVPs are mentioned on the web. So I have both a news and a web alert set for "microsoft" "mvp." Whenever new info is found, I get an email about it and a link to that information.
http://www.google.com/alerts

These simple VBA routines will quickly highlight cells with formulas, constants, text, or errors. They're great for auditing worksheets.
Sub MapFormulas()
Cells.SpecialCells(xlFormulas).Interior.ColorIndex = 6
End Sub

Sub MapConstants()
Cells.SpecialCells(xlConstants, xlNumbers).Interior.ColorIndex = 6
End Sub

Sub MapText()
Cells.SpecialCells(xlConstants, xlTextValues).Interior.ColorIndex = 6
End Sub

Sub MapErrors()
Cells.SpecialCells(xlFormulas, xlErrors).Interior.ColorIndex = 6
End Sub

Don't open Outlook to email a file. Just right click on the file, scroll to Send To, click on Mail Recipient, enter the recipient's email address, and click on Send.

Toogle is a Text version of Googles Image Search. It will fetch the first image on google image search result page and convert the image into a text layout. It seems that they have developed a software that will understand the colour shades used in the image and apply the same colour shade at the specific pixel point! Still in the beta stage, looks promising.
http://www.c6.org/toogle

The Gmail Notifier is a downloadable Windows application that alerts you when you have new Gmail messages. It displays an icon in your system tray to let you know if you have unread Gmail messages, and shows you their subjects, senders and snippets, all without your having to open a web browser. To use the Gmail Notifier, you need Windows 2000, Windows XP, or a more recent version of Windows.

flickr is the best image host service next to yahoo photos. Once you are a registered user, you can upload the photos by e-mailing it to the address given to you. You can also use the bookmarklet to post a photo that you see online. Once it's in your album, you can create sets and organize your photos. Use Tags in the description so that it will be easy to find the photos later. If you decide to publish your photos, you can give a URL to your friends or a RSS feed. Tag based RSS feeds are available as well! What's more, you can even post your photos on blogger or livejornal blog. It means you can turn any blog into a moblog - just like that!
http://www.flickr.com/photos/shantanuo/
neon RSS feeds here...
http://tinyurl.com/3sv2o