convert yyyymmdd text cells into date cells

I need to convert a text cell into date cell but reversing the format.
It looks like 20051231 and it should be convert it to date because I need to
use it on a chart as x axis.

=?Utf-8?B?ZF9jYW1wZWxvQGhvdG1haWwuY29t?=

Here's one solution:
1. Put your original data in a hidden column (let's say "E")
2. In another column, add the following format:
=MID($E1,5,2) & "/" & MID($E1,7,2) & "/"& MID($E1,1,4)
This will convert your yyyymmdd to mm/dd/yyyy for use in your chart.

Hope this helps.
--
Larry J. West, MCSD, MOUS, FLMI, ACS


"" wrote:

> I need to convert a text cell into date cell but reversing the format.
> It looks like 20051231 and it should be convert it to date because I need to
> use it on a chart as x axis.

=?Utf-8?B?TGFycnlXZXN0TUNTRA==?=

Larry,
I should have thought of somthing on those lines.
Thanks for the help. How can I rate your responce? I responded that your
message was helpfull but I didn't ask me to scale it.

thank again.

dario,

"LarryWestMCSD" wrote:

> Here's one solution:
> 1. Put your original data in a hidden column (let's say "E")
> 2. In another column, add the following format:
> =MID($E1,5,2) & "/" & MID($E1,7,2) & "/"& MID($E1,1,4)
> This will convert your yyyymmdd to mm/dd/yyyy for use in your chart.
>
> Hope this helps.
> --
> Larry J. West, MCSD, MOUS, FLMI, ACS
>
>
> "" wrote:
>
> > I need to convert a text cell into date cell but reversing the format.
> > It looks like 20051231 and it should be convert it to date because I need to
> > use it on a chart as x axis.

=?Utf-8?B?ZF9jYW1wZWxvQGhvdG1haWwuY29t?=