ALLAROUNDOFFICE
Board Regular
- Joined
- Apr 26, 2014
- Messages
- 61
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?
If I type 042614 in A3, Excel changes it to 09/01/16. If I type 042614 in A4, Excel changes it to 042614...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.
Okay, I tried to attach a screen shot, but guess I can't.Whatever you attempted to show us in this message did not post correctly.
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...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...
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...FYR.
Convert an 8-digit number into Excel-recognizable Date | wmfexcel
This is actually inspired by Rick some time ago.
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?Try one of the add-ins shown in my signature line at the bottom of this message...