| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text format to date format ?
Hi all,
I have the column of date in general/text format as "20080402", how can i change it into date format, is there any format to change directly? Thanks a lot |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text format to date format ?
Hi,
Select the column then Data|Text to columns Next Next Select Date From the dropdown select YMD or (YDM) if that is how the date is formatted OK Mike "aozora" wrote: Hi all, I have the column of date in general/text format as "20080402", how can i change it into date format, is there any format to change directly? Thanks a lot |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Linear Mode
