Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am looking to have the symbol & written in my header, i tried many ways
"&", ="&", '&', ... it just won't show up. Is there anyway to make it show up ? Maybe ascii code but i don't know how ?? PLEASE, do not answer to write "and" instead, I had already figured this one out :) |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It is oh-so-simple when you know how. You got very close!
Use two & symbols as in: Mutt && Jeff best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Jean-Marc P" wrote in message ... I am looking to have the symbol & written in my header, i tried many ways "&", ="&", '&', ... it just won't show up. Is there anyway to make it show up ? Maybe ascii code but i don't know how ?? PLEASE, do not answer to write "and" instead, I had already figured this one out :) |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The answer that Bernard gave is subtly hidden away in "Formatting codes for
Headers and Footers" in the VBA help file. "Jean-Marc P" wrote: I am looking to have the symbol & written in my header, i tried many ways "&", ="&", '&', ... it just won't show up. Is there anyway to make it show up ? Maybe ascii code but i don't know how ?? PLEASE, do not answer to write "and" instead, I had already figured this one out :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to put special character "&" in Excel Header / Footer ? | Excel Discussion (Misc queries) | |||
excel displays "l" instead of "‚¬" symbol for Euro values | Excel Discussion (Misc queries) | |||
How to use "&" character in header or footer; won't print | Excel Discussion (Misc queries) | |||
Listbox header inside VBA (Array("Head1", "Head2", ...) | Excel Programming | |||
How do i use the "&" symbol in a header in excel? | Excel Discussion (Misc queries) |