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

P

Pecoflyer

Sherry;215905 said:
Doesn't work in Excel. Actually, I solved my problem...

=left(a1,2) & "/" & mid(a1,4,2) & "/" & right(a1,4)

Thanks anyway!!!
Click to expand...

Teethless mama's method works perfectly in XL, but you have to chang
the search options to " search in formulas

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
S

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.
 
G

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
 
S

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.
 
D

David Biddulph

Well, I'm fascinated that you can get a date of 10-00-2083. The mind
boggles.
 
Top