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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Replace "/" with "-" in a number formatting (https://www.excelbanter.com/excel-discussion-misc-queries/219328-re-replace-number-formatting.html)

Teethless mama

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

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

All times are GMT +1. The time now is 08:18 PM.