How to put "&" in header / footer of Excel sheet

I have a client whose business is called (say) "A & B Foods." They produce their invoices on Excel and would like their name to appear as a header on each sheet. Although the name can be entered in a cell on each sheet, I can't get Excel to make it a page header. When using Print preview, Setup,Header/Footer, Custom Header (or Footer) then typing in "A & B Foods", Excel refuses to print the "&" in the name. (They want an "&" instead of "and"). How do I get Excel to do this?
Adrian Wilkinson

Comments
There are 4 comments. Login or register to view them.

How to put "&" in header / footer of Excel sheet

dragan |

"&" in Excel header/footer

0411134 |

Why use Excel for accounting work?

mikeopolo |

Entering an ampersand in Excel header or footer

shurst |
shurst's picture