View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PW[_3_] PW[_3_] is offline
external usenet poster
 
Posts: 2
Default Reverse cell value and convert to date

Hello newsgroup users and Gurus.

Your kind assistance please.

This is a challenge.

I have a column with a text string which is a date. i'e.

30121998= 30th December 1998.

I would like to convert the text string into a actual date
format.

A tricky one I know, but is it possible.

Regards
Paul