View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dancinbran dancinbran is offline
external usenet poster
 
Posts: 1
Default How do I get the "&" to show in a name in a header in Excel?

I am trying to get a company name to show up in a custom header, but the & is
used for formatting and so it doesn't show up in the header. A & A Produce
looks like A A Produce. Any ideas? I tried putting an apostrophe in front of
the text, but that only seems to work inside the cells. I am using Office
Excel 2003. Thanks!