Automatically Changing Numbers to Date

**Intoxicated-T-F** · 12-07-2007, 02:32 PM

Hello,

My question has to do with the way Excel formats numbers and dates in Excel. I would like to be able to type "052407" in a cell and have it automatically change to "05/24/07." A makeshift way of doing this is to Right-click, format cell, click Custom, and type "##-##-##" in the Type field (it won't allow slashes for some reason). However, Excel doesn't read this data as a date, it still thinks of it as a number. I would like the data I enter into a cell to be read as a date.

Is my question clear?

Thank you!

**Ron Coderre** · 12-07-2007, 02:59 PM

Perhaps this method will work for you...

Enter the "dates" as you described
When done....
Select the column of dates

From the Excel Main Menu
<data><text-to-column>
....Click [Next]
....Click [Next]
....Check: Date.....MDY
....Click [Finish]

The inputs will become actual dates.

Is that something you can use?

**Leith Ross** · 12-07-2007, 03:02 PM

Hello Intoxicated-T-F,

Have a look at Chip Pearson's page on this...

Dates - Quick Entry

Sincerely,
Leith Ross

**VBA Noob** · 12-07-2007, 03:09 PM

To add to Ron suggestions.

Right click sheet tab > Select view code > paste in the below code.

The code assumes Column A is in text format and when you type 052407 it converts it too 24/05/2007

Change Range to your range.

Please Login or Register  to view this content.

VBA Noob

**Intoxicated-T-F** · 12-07-2007, 05:47 PM

Thanks all! The link provided helped, and was exactly what I was looking for.

Automatically Changing Numbers to Date

LinkBack

Thread Tools

Rate This Thread

Display

Automatically Changing Numbers to Date

Automatically Changing Numbers to Date

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions