Date stuck as text

[Ali]

I'm using a web query to bring in a table containing
several dates. I use the VALUE function to make excel
recognize the dates as numbers and then I format the cell
as mmmm dd, yyyy. This works fine on my PC but the person
I'm working with sees #VALUE error. How do I fix this?

Thanks, Ali

 

[Frank Kabel]

Hi
this person probably has different regional settings. What is the
format of the importedt date values?

 

[Ali]

The text from the web query comes in as: July 22, 2004

 

[Frank Kabel]

Hi
you may try the following formula instead of your VALUE formula
=DATEVALUE(MID(A1,FIND(" ",A1)+1,FIND(",",A1)-FIND(" ",A1)-1) & "-" &
LEFT(A1,FIND(A1," ")-1 & "-" & RIGHT(A1,4))

In addition have a look at 'Data - text to columns' to convert your
values to real date values