| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting text into Date Value
If your original text format still exists, then there shouldn't be a need to split them up. Select the cells containing the dates, then go to DateText to Columns and skip to the 3rd dialogue. From the date drop down, select MDY and then click Finish. The cells should now be true dates. You can then format them however you want through FormatCells -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=493595 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Text Entry to Date Format | Excel Discussion (Misc queries) | |||
| Date to Text | Excel Worksheet Functions | |||
| Date stored as Text | Excel Discussion (Misc queries) | |||
| Date to text format | Excel Discussion (Misc queries) | |||
| Macro to convert text to date | Excel Worksheet Functions | |||
Threaded Mode
