Change number format/convention

[mLife9320]

I would like to know if there is a formula to make a numbering format standardised. I have a work sheet, with a column that contains data similar to below:

45-02-001
45-02-002
45/02/003
45-02-004
45/02/005
45-02-006

Some of the fields separate the numbers with "-" and others with "/" (due to inconsistent inputting). I would like formula to convert "-" to "/" (or any type of separator).

There are over 1000 rows, so I required an automated solution

Thanks

 

[Joe4]

Are they really formatted like that (meaning that the "/" and "-" don't really appear in the date, they are really numbers with different formats)?
If the "/" and "-" are really part of the data, then you can simply do a Find/Replace (i.e. replacing "-" with "/") choosing the Replace All option to fix them instantly all at once.

 

[mLife9320]

Are they really formatted like that (meaning that the "/" and "-" don't really appear in the date, they are really numbers with different formats)?
If the "/" and "-" are really part of the data, then you can simply do a Find/Replace (i.e. replacing "-" with "/") choosing the Replace All option to fix them instantly all at once.

Oh my gosh! I completely forgot about find and replace <palms face!> ... and yes they are formatted that way. Its to identify locations on industrial estate (e.g. Building/Floor/Room).

Thanks so much for your assistance.

 

[Joe4]

You are welcome.