Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text String to Date
I have been reading many many posts regarding this topic, but of course none
seems to be exactly what I am looking to do. So.. I have an InputBox getting a string and it has been doing what I want. I want the user to give me a 6 digit date that I incorporate into a filename later on. FileDate = InputBox("Enter the 6 digit date of file" & vbLf & "(Example: 031208)", "Date of SCR Data") BUT at the same time I'd like the input to go into one of the cells as a date "m/d/yy". What I have been getting is a date "6/10/85" which I understand is the date equivalent for day #31208. What I'd like to see is "03/12/08" or "3/12/08". Any help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separate Date from a Text String | Excel Worksheet Functions | |||
Date in Text String | Excel Worksheet Functions | |||
VBA convert day and date from text string to Excel date | Excel Programming | |||
How do i parse a text string with a date? | Excel Programming | |||
Help !, to find last 'text' date in text string | Excel Programming |