View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim Whitley
 
Posts: n/a
Default HOW DO I ENTER THIS FORMULA TO CONVERT TEXT TO DATE =DATEVALUE(,

You should exclude the commas =DATEVALUE(A131)

Also, make sure you format the cell with the formula in it to the date
format that you require.

"Carter" wrote:

I am having a problem converting dates stored as text to dates. I keyed in
=DATEVALUE(,A131,). However it keeps giving me an error message. Please help!

Thank You,

Carter