View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jim Davis
 
Posts: n/a
Default Number and text format in the same call

I'm trying to change the format of the following"

12345678
to
123-45-678 -- in other words, adding the dashes. Some of the numbers are the
same 8 digits, but also have a letter. They are currently:

12345678A
to
123-45-678A

Thank you,