Date stuck as text

  • Thread starter Thread starter Ali
  • Start date Start date
A

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
 
Hi
this person probably has different regional settings. What is the
format of the importedt date values?
 
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
 
Back
Top