View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default convert a text date to a true date

On Wed, 14 Nov 2007 17:39:27 -0800 (PST), Pete_UK wrote:

Rick,

this doesn't work in the UK, as

March 3, 2002

is not a valid date string. I'll post my solution direct to the OP.

Pete


Thanks for pointing that out, Pete. I just confirmed it here by changing my
Regional settings to UK.
--ron