ExcelBanter - text format to date format ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - text format to date format ? (https://www.excelbanter.com/excel-worksheet-functions/226470-text-format-date-format.html)

aozora

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

Mike H

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

All times are GMT +1. The time now is 04:53 AM.