convert a text date to a true date

  • Thread starter Thread starter Guest
  • Start date Start date
Are you now saying that my SUBSTITUTE formula above does, in fact, work in
locales other than the US (provided the comma is present)?
Click to expand...

No. I was simply pointing out that DATEVALUE doesn't recognize mmmm d yyyy
as a valid date string in either U.S. or UK regional settings. You would
think (at least, I would think) that mmmm d yyyy should be a valid date
string in the U.S. since it *is* a valid date format.

A1 = 3/3/2007

Custom format as mmmm d yyyy

A1 displays March 3 2007
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting date to text 2
Convert military date system to standard date system 8
Date without true value 5
Convert text dates 4
Simple Methods to Export Gmail to Text? 1
convert text to date 2
Copnvert dates reading as Text to a date format 5
Convert text date to mmddyyy date 2

Back
Top