converting 20071231 to 12/31/2007

[InvGrp2]

I did a search prior to posting this but to be honest the posts were a bit confusing.

Any help would be appreciated in converting 20071231 to 12/31/2007.

Bruce

[shg]

=DATE(LEFT(A1,4), MID(A1,5,2), RIGHT(A1,2))

[InvGrp2]

That worked perfectly (conversion).

I now need to get the results (without the formula) into another cell.

Note: I need to use the 12/31/2007 data (no formula) in another spreadsheet.

Thanks.

Bruce

[daddylonglegs]

You could actually convert your "dates" in situ using:

Data > Text to Columns > Next > Next > at step 3 from "column data format" select "Date" and YMD. You can now copy this data to another sheet

If you used shg's formula to convert than you can copy the converted data and use Edit > Paste Special > Values to copy just the date value without the formula.

Note: You could also use this formula to convert

=TEXT(A1,"0000-00-00")+0

format as date

[InvGrp2]

The paste special worked great.

Thanks again.

Bruce