ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "&" symbol in header/footer (https://www.excelbanter.com/excel-programming/418000-symbol-header-footer.html)

Jean-Marc P

"&" symbol in header/footer
 
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 :)

Bernard Liengme

"&" symbol in header/footer
 
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 :)




JLGWhiz

"&" symbol in header/footer
 
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 :)



All times are GMT +1. The time now is 04:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com