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

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

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

On 4 Apr, 11:08, Kishalin <Kishalin @discussions.microsoft.com wrote:
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

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

Hi Kishalin,

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

HTH
Martin



"Kishalin" <Kishalin @discussions.microsoft.com wrote in message
...
How would i change the format of a cell with out retyping the information.
e.g 02.02.08 to 02/02/08

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

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

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

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

Regards,
Stefi


€žKishalin€� ezt Ã*rta:

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

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

DataText to ColumnsNextNextColumn Data FormatDate.

The example posted is ambiguous

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


Gord Dibben MS Excel MVP

On Fri, 4 Apr 2008 03:08:02 -0700, Kishalin <Kishalin
@discussions.microsoft.com wrote:

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