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