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
|