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 Edit>Replace
Find what: .
Relace with: /
Click Replace All

HTH
Martin



"Kishalin" <Kishalin @discussions.microsoft.com> wrote in message
news:073905A6-BA9E-4F7F-8294-(E-Mail Removed)...
> 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

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

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