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

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

Hi!

A1 = text string = 1/1/2006

Formula to convert to a true Excel DATE:

=--A1

Format cell as DATE

Biff

"Carter" wrote in message
...
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

Tim,

Just to clarify to you what I did... I formatted the cell with the formula
in it to the date that I wanted ie.12/30/2005. I then moved to a blank cell
and keyed =DATEVALUE(A131). However, it still gave me an error message. I
am trying to covert text to dates and I have a several spreadsheets that I
need to do this for.

Anymore suggestions?

Carter

"Tim Whitley" wrote:

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

I'm not sure if I understand... I tried that but it gave me an error message.
I wanted to covert text to dates.

carter

"Biff" wrote:

Hi!

A1 = text string = 1/1/2006

Formula to convert to a true Excel DATE:

=--A1

Format cell as DATE

Biff

"Carter" wrote in message
...
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