View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Brow Greg Brow is offline
external usenet poster
 
Posts: 29
Default formatting macro

Hi all

I have a series of numbers 123456789 and it is followed with a letter a

I need to show on a worksheet in this format 123-456-789a I cant work out
how to set the cell i have tried 000-000-000 but not sure how to get it to
recognise the letter after

Thanks in advance

greg