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

Doesn't work in Excel. Actually, I solved my problem...

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

Thanks anyway!!!

"Teethless mama" wrote:

Ctrl-H
Find what: -
Replace with: /
Replace All


"Sherry" wrote:

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

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

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

Thanks anyway!!!

"Teethless mama" wrote:

Ctrl-H
Find what: -
Replace with: /
Replace All


"Sherry" wrote:

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

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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59301

Hi Sherry
Goto Edit Find Replace
HTH
John
"Sherry" wrote in message
...
How do I replace / with - in a number
ex: 10-00-2830 with 10/00/2830

I think you'll find that Teethless mama would not have suggested it if it
doesn't work in Excel.
It does work.

It wouldn't work if the character you had as the 3rd and 6th characters
wasn't a hyphen as you'd typed it in this message but some special character
such as a non-breaking hyphen, an em-dash, or an en-dash. You can find out
what character it is by using =CODE(MID(A1,3,1)) If the answer isn't 45,
you haven't got a hyphen.
--
David Biddulph

Sherry wrote:
Doesn't work in Excel. Actually, I solved my problem...

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

Thanks anyway!!!

"Teethless mama" wrote:

Ctrl-H
Find what: -
Replace with: /
Replace All


"Sherry" wrote:

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

If the concatenation method worked, then that means it wasn't in a formula.
I'm guessing maybe the OP just typed TM's instructions into the spreadsheet
instead of doing them?

"Pecoflyer" wrote:


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

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

Thanks anyway!!!

"Teethless mama" wrote:

Ctrl-H
Find what: -
Replace with: /
Replace All


"Sherry" wrote:

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

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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59301

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.

"David Biddulph" wrote:

I think you'll find that Teethless mama would not have suggested it if it
doesn't work in Excel.
It does work.

It wouldn't work if the character you had as the 3rd and 6th characters
wasn't a hyphen as you'd typed it in this message but some special character
such as a non-breaking hyphen, an em-dash, or an en-dash. You can find out
what character it is by using =CODE(MID(A1,3,1)) If the answer isn't 45,
you haven't got a hyphen.
--
David Biddulph

Sherry wrote:
Doesn't work in Excel. Actually, I solved my problem...

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

Thanks anyway!!!

"Teethless mama" wrote:

Ctrl-H
Find what: -
Replace with: /
Replace All


"Sherry" wrote:

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

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


On Thu, 5 Feb 2009 14:33:21 -0800, Sherry
wrote:

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.

"David Biddulph" wrote:

I think you'll find that Teethless mama would not have suggested it if it
doesn't work in Excel.
It does work.

It wouldn't work if the character you had as the 3rd and 6th characters
wasn't a hyphen as you'd typed it in this message but some special character
such as a non-breaking hyphen, an em-dash, or an en-dash. You can find out
what character it is by using =CODE(MID(A1,3,1)) If the answer isn't 45,
you haven't got a hyphen.
--
David Biddulph

Sherry wrote:
Doesn't work in Excel. Actually, I solved my problem...

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

Thanks anyway!!!

"Teethless mama" wrote:

Ctrl-H
Find what: -
Replace with: /
Replace All


"Sherry" wrote:

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

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.


"Gord Dibben" wrote:

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


On Thu, 5 Feb 2009 14:33:21 -0800, Sherry
wrote:

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.

"David Biddulph" wrote:

I think you'll find that Teethless mama would not have suggested it if it
doesn't work in Excel.
It does work.

It wouldn't work if the character you had as the 3rd and 6th characters
wasn't a hyphen as you'd typed it in this message but some special character
such as a non-breaking hyphen, an em-dash, or an en-dash. You can find out
what character it is by using =CODE(MID(A1,3,1)) If the answer isn't 45,
you haven't got a hyphen.
--
David Biddulph

Sherry wrote:
Doesn't work in Excel. Actually, I solved my problem...

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

Thanks anyway!!!

"Teethless mama" wrote:

Ctrl-H
Find what: -
Replace with: /
Replace All


"Sherry" wrote:

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

Thanks John!!!

"John" wrote:

Hi Sherry
Goto Edit Find Replace
HTH
John
"Sherry" wrote in message
...
How do I replace / with - in a number
ex: 10-00-2830 with 10/00/2830

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

Sherry wrote:
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.


"Gord Dibben" wrote:

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


On Thu, 5 Feb 2009 14:33:21 -0800, Sherry
wrote:

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.

"David Biddulph" wrote:

I think you'll find that Teethless mama would not have suggested
it if it doesn't work in Excel.
It does work.

It wouldn't work if the character you had as the 3rd and 6th
characters wasn't a hyphen as you'd typed it in this message but
some special character such as a non-breaking hyphen, an em-dash,
or an en-dash. You can find out what character it is by using
=CODE(MID(A1,3,1)) If the answer isn't 45, you haven't got a
hyphen. --
David Biddulph

Sherry wrote:
Doesn't work in Excel. Actually, I solved my problem...

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

Thanks anyway!!!

"Teethless mama" wrote:

Ctrl-H
Find what: -
Replace with: /
Replace All


"Sherry" wrote:

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