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

K

Kishalin

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

Paul

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

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

MartinW

Hi Kishalin,

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

HTH
Martin
 
J

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

Stefi

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

Regards,
Stefi


„Kishalin†ezt írta:
 
G

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
 
Top