Thread: Inserting "-" dashes into number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lisa W Lisa W is offline
external usenet poster
  
Posts: 6
Default Inserting "-" dashes into number
I have a number that is always this format: 1993200000002000-02
and I need it to be this format: 199-32-0-00-00-002-00-0-02

Is there an easy formula to make this so?

Thanks, Lisa
Reply With QuoteReply With Quote