transforming a date

B

bernd.vd.berg

I've a column with a date written as follows 20060801. (first of august
2006)

I want to transform this date into 01-08-2006

Does anyone know how to do this?


Bernd
 
D

Dave Peterson

Select the column
data|Text to columns
Fixed width (but don't have any lines to separate fields)
choose date ymd (or ydm, I can't tell!)
and finish up.

Format the column the way you want.
 
P

Pete_UK

Assuming your data is in A2, try this in B2:

=VALUE(RIGHT(A2,2)&"/"&MID(A2,5,2)&"/"&LEFT(A2,4))

Format the cell in the date format you require, then copy down the
column for as many entries as you have in column A.

Hope this helps.

Pete
 
Top