Thread: Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
j.a. harriman j.a. harriman is offline
external usenet poster
  
Posts: 3
Default Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho
Hi,
I have a column "A" of "dates" in text of DDMMMYY format, such as "30Mar98".

I either need to convert all the values in the existing column to datetime
values (YYYY-MM-DD) or create a new column "B" that contains the converteed
values.

How is this done?

Thanks.
Reply With QuoteReply With Quote