HOW DO I ENTER THIS FORMULA TO CONVERT TEXT TO DATE =DATEVALUE(,

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" <Carter@discussions.microsoft.com> wrote in message
news:49DB0CA5-E796-4972-9568-CA5E145F61A0@microsoft.com...
>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" <Carter@discussions.microsoft.com> wrote in message
> news:49DB0CA5-E796-4972-9568-CA5E145F61A0@microsoft.com...
> >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
> >
>
>
>