Thread: convert to date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geebee geebee is offline
external usenet poster
 
Posts: 190
Default convert to date

hi,

i have values like:
DDDJun 08
in a column.

I want to know if there is a formula i can have in the next column to
convert these values to dates in the format like "Jun-08", with 08 being the
year 2008. So for example, if the value was TWIJun 09, it would be converted
to "Jun-09"

is there a formula i could use? or would i have to do this programatically?

thanks in advance,
geebee