| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different Date formats in text to be recognised as date value
Hi all,
I have a problem with some date formats where people send to me in various forms (text format) 1) "DD\MM\YYYY" 2) "D\MM\YYYY" 3) "D\M\YYYY" 4) "MM\DD\YYYY" 5) "MM\D\YYYY" 6) "M\D\YYYY" Is there anyway to be able to convert these to date values and be reflected as "DD\MM\YYY" using vba. Thank you for any help rendered in advance. Rgds Ray |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Formats in Text Box | Excel Discussion (Misc queries) | |||
| The Cell formats keep changing itself from text to date | Excel Discussion (Misc queries) | |||
| US date needs reformatting but not recognised by my UK computer | Excel Programming | |||
| how do i change 20050614 within in a cell to a recognised date | Excel Worksheet Functions | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
Threaded Mode
