Home |
Search |
Today's Posts |
#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 ... 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 ... 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 ... 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 ... 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 ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |