| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Date string to date format
In that case, both your alternate colutions are good.
-- Gary''s Student - gsnu201002 "Joe M." wrote: All my date strings have 2 charactors for the month so "7" would be 200907... "Gary''s Student" wrote: You are correct! MID(A4,5,2) is just as good. RIGHT(A4,2) not so good......consider 20097 -- Gary''s Student - gsnu201002 "Joe M." wrote: It works great! But I don't understand why its necessary to use 256 in MID(A4,5,256) instead of MID(A4,5,2) or even RIGHT(A4,2). Maybe you can shed some light on that. Thanks! "Gary''s Student" wrote: =DATE(LEFT(A4,4),MID(A4,5,256),1) and format as mmm-yyyy -- Gary''s Student - gsnu201002 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert dd/mm/yy date format to yyddd Julian date format | Excel Worksheet Functions | |||
| How do I convert US date with 12hr format to European date 24hr | Excel Discussion (Misc queries) | |||
| Convert worksheet string name to date format in cell | Excel Worksheet Functions | |||
| Convert european foreign date format to US date format | Excel Worksheet Functions | |||
| convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
Threaded Mode
