you an auxilary cell and put in this function to convert to a date format.
Besure the cell with the formul is formated as a date. If you want to put
the data back into the original cell then do a copy and paste special using
value only.

=DATEVALUE(LEFT(F1,2)&"/"&MID(F1,4,2)&"/"&RIGHT(F1,2))

"Kishalin" wrote:

How would i change the format of a cell with out retyping the information.
e.g 02.02.08 to 02/02/08