How would i change the format of a cell with out retyping the information.
e.g 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

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

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

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

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