If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Input Masks in Excel?
Does Excel have input masks, similar to Access? I would like the user to
enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
#2
|
|||
|
|||
No, it's all manual.
-- HTH Bob Phillips "PattiP" wrote in message news Does Excel have input masks, similar to Access? I would like the user to enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
#3
|
|||
|
|||
Thanks, Bob. I thought thats what the anwer might be...
"Bob Phillips" wrote: No, it's all manual. -- HTH Bob Phillips "PattiP" wrote in message news Does Excel have input masks, similar to Access? I would like the user to enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
#4
|
|||
|
|||
Is there a way to convert the entry, i.e. 032405, and have it show up in
another cell in date format? Some kind of VB code? "Bob Phillips" wrote: No, it's all manual. -- HTH Bob Phillips "PattiP" wrote in message news Does Excel have input masks, similar to Access? I would like the user to enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
#5
|
|||
|
|||
If you have got a lot, take a look at
http://www.xldynamic.com/source/xld.QDEDownload.html -- HTH Bob Phillips "PattiP" wrote in message ... Is there a way to convert the entry, i.e. 032405, and have it show up in another cell in date format? Some kind of VB code? "Bob Phillips" wrote: No, it's all manual. -- HTH Bob Phillips "PattiP" wrote in message news Does Excel have input masks, similar to Access? I would like the user to enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
#6
|
|||
|
|||
or try this
Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then With Target .Value = DateSerial(Right(.Value, 2), Left(.Value, Len(.Value) - 4), Mid(.Value, Len(.Value) - 3, 2)) End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips "Bob Phillips" wrote in message ... If you have got a lot, take a look at http://www.xldynamic.com/source/xld.QDEDownload.html -- HTH Bob Phillips "PattiP" wrote in message ... Is there a way to convert the entry, i.e. 032405, and have it show up in another cell in date format? Some kind of VB code? "Bob Phillips" wrote: No, it's all manual. -- HTH Bob Phillips "PattiP" wrote in message news Does Excel have input masks, similar to Access? I would like the user to enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I want to delete some customized input masks. | Swimfast | Database Design | 13 | March 21st, 2005 10:41 PM |
Input masks for postal codes (UK) in Access | James | General Discussions | 4 | February 14th, 2005 07:03 PM |
Input masks | Annie | Using Forms | 3 | February 9th, 2005 08:55 PM |
Input Masks | mk2 | Database Design | 1 | October 31st, 2004 08:52 PM |
input masks | Zariah | General Discussion | 1 | October 3rd, 2004 06:22 AM |