Office Tips and Hints Blog

Home Page

Host your Web site with PureHost!

Sunday, November 30, 2008 – Permalink –

Time Without Limits

No Delimiters

Excel is most happy when you enter dates and times with the correct separators.

1/1/2004 is a good date. So is 1-1-2004.

If you just entered 112004 in a cell formatted as a date you'll get:

Wednesday, August 27, 2206

the 112,004^th day since January 1, 1900.

Chip Pearson has come up with VBA code, using the Worksheet_Change event procedure, that will allow you to enter dates without dashes or slashes.

See:
Date And Time Entry

[Updated entry from 9/24/2005]

See all Topics

Labels: Excel

<Doug Klippert@ 3:43 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link