Replace "/" with "-" in a number formatting

[Sherry]

How do I replace / with - in a number
ex: 10-00-2830 with 10/00/2830

 

[Sherry]

No disrespect to Teethless mama but it does not work. Excel is recognizing
10/01/2009 as a date and changes nothing even when I change the format to
date in the "find what / replace with" window . I'm obviously missing
something.

 

[Gord Dibben]

Your original example was 10-00-2083

TM's suggestion was predicated upon that example and it does work

Where did 10/01/2009 come from?


Gord Dibben MS Excel MVP

 

[Sherry]

I apologize for wasting you time.

My co-worker renigged and gave me wrong request. She wanted 10/00/2083 to
be 10-00-2083. Resolution was: =TEXT(A10,"mm-dd-yyyy") so simple.

 

[Sherry]

Thanks John!!!

Hi Sherry
Goto Edit > Find > Replace
HTH
John