Thread: Macro question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tina tina is offline
external usenet poster
 
Posts: 139
Default Macro question

I need a macro that will add the text -0000 at the end of whatever text is in
that current cell.

For example Cell = 75154

I need to add -0000 at the end of this so then it will be

75154-0000

I have tried all the formating stuff, but the Zipcode cell format doesnt
work.