#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 73
Default Excel 2003 and 2007

When typing in a custom header the "&" sign will not show up. For
example:

"Smith & Jones" will come out as "Smith Jones". Is there a way around this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,533
Default Excel 2003 and 2007

Hi

Use two & signs:

Smith && Jones

Regards,
Per


"RENEE" skrev i meddelelsen
...
When typing in a custom header the "&" sign will not show up. For
example:

"Smith & Jones" will come out as "Smith Jones". Is there a way around
this?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 73
Default Excel 2003 and 2007

Thank you - worked like a charm!

"RENEE" wrote:

When typing in a custom header the "&" sign will not show up. For
example:

"Smith & Jones" will come out as "Smith Jones". Is there a way around this?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 vs 2003 glenk Excel Discussion (Misc queries) 4 February 2nd 09 08:03 AM
Excel 2003 to 2007 NirOrtal Excel Discussion (Misc queries) 3 November 21st 08 10:13 PM
Excel 2003 vs. 2007 PeeJayEm Excel Discussion (Misc queries) 2 September 14th 08 12:09 AM
Excel 2007 Macro Help (Excel 2003 not working in 2007) Pman Excel Discussion (Misc queries) 4 May 29th 08 06:29 PM
2007 & 2003 Excel Velcroman Excel Discussion (Misc queries) 1 April 11th 07 01:26 PM


All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"