Typing in dates

[ALLAROUNDOFFICE]

How can I hard code a column of cells to convert the user entered data of "042614" or "42614" into a specific date format such as 04/26/2014?

 

[ALLAROUNDOFFICE]

No yellow lines...

 

[Rick Rothstein]

Whatever you attempted to show us in this message did not post correctly.

 

[MARK858]

Then I'm stumped. All I can suggest is putting your workbook on a file hosting site like Box.com, make sure you mark it for sharing and post a link in the thread.

 

[ALLAROUNDOFFICE]

Then I'm stumped. All I can suggest is putting your workbook on a file hosting site like Box.com, make sure you mark it for sharing and post a link in the thread.

If I type 042614 in A3, Excel changes it to 09/01/16. If I type 042614 in A4, Excel changes it to 042614...

 

[ALLAROUNDOFFICE]

Whatever you attempted to show us in this message did not post correctly.

Okay, I tried to attach a screen shot, but guess I can't.

 

[Rick Rothstein]

Try one of the add-ins shown in my signature line at the bottom of this message...

 

[ALLAROUNDOFFICE]

Then I'm stumped. All I can suggest is putting your workbook on a file hosting site like Box.com, make sure you mark it for sharing and post a link in the thread.

Is there any other way around this? Can I just type in a formula instead of doing the event code thing since that is not going to work on my system for some reason...All I need is to convert the digits entered by the user to a six digit date with slashes...

 

[mfexcel]

FYR.
Convert an 8-digit number into Excel-recognizable Date | wmfexcel
This is actually inspired by Rick some time ago.

Is there any other way around this? Can I just type in a formula instead of doing the event code thing since that is not going to work on my system for some reason...All I need is to convert the digits entered by the user to a six digit date with slashes...

 

[ALLAROUNDOFFICE]

FYR.
Convert an 8-digit number into Excel-recognizable Date | wmfexcel
This is actually inspired by Rick some time ago.

I read the article, but I am somewhat of a novice on formulas. All of the cells are blank right now and the users will be typing in a date as the sale happens. As you probably know, every person types in dates differently so I want to hard code the sale date column to convert to a six or eight digit date with slashes regardless of how the user types it in..i.e. for April 26th, 2014 I've seen 42614, 4262014, 042614, 04262014, 4-26-14, 04-26-2014, etc...

 

[ALLAROUNDOFFICE]

Try one of the add-ins shown in my signature line at the bottom of this message...

Could you possibly send me a screen shot showing the code entered in the box. This way perhaps I can see what is different between our two entries?