| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting a cell text to date
I have a column which contains a text value which translate to yyyymm such
as 200210, 200405. I would like to change this column to a date of format mm/dd/yyyy. I would default the day to 01. 200210 - 01/10/2002 Any help on this would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting date to text | Excel Discussion (Misc queries) | |||
| Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
| converting date to text | Excel Worksheet Functions | |||
| Converting text into Date Value | Excel Worksheet Functions | |||
| converting text in cell to a date time | Excel Worksheet Functions | |||
Threaded Mode
