Thread: Replace "/" with "-" in a number formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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
Reply With QuoteReply With Quote