How do i change format of cell from 02.02.08 to 02/02/08?

[Kishalin]

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

 

[Paul]

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

A quick way is ti highlight all cells anf Find & Replace

 

[MartinW]

Hi Kishalin,

Assuming your data is text
Select your data
Go to Edit>Replace
Find what: .
Relace with: /
Click Replace All

HTH
Martin

 

[Joel]

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))

 

[Stefi]

Is it a real Excel date cell (not text)? If so, apply custom cell format
"mm/dd/yy"

Regards,
Stefi


„Kishalin†ezt írta:

 

[Gord Dibben]

Data>Text to Columns>Next>Next>Column Data Format>Date.

The example posted is ambiguous

You decide if MDY or DMY depending upon short date settings in Regional
Settings.


Gord Dibben MS Excel MVP