| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert dates stored as text to dates
What is the VB code to convert dates stored as text to excel formatted dates?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert dates stored as text to dates
Something like
cdate("12 sep 2004") -- HTH RP (remove nothere from the email address if mailing direct) "lenko" wrote in message ... What is the VB code to convert dates stored as text to excel formatted dates? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert dates stored as text to dates
ActiveCell.Value = ActiveCell.Value
ActiveCell.NumberFormat = "mm/dd/yyyy" -- Regards, Tom Ogilvy "lenko" wrote in message ... What is the VB code to convert dates stored as text to excel formatted dates? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert dates stored as text | Excel Discussion (Misc queries) | |||
| Convert text to dates | Excel Discussion (Misc queries) | |||
| How do I convert dates stored as dates to text? | Excel Discussion (Misc queries) | |||
| Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Hybrid Mode
