Tip Printed from ExcelTip.com

---

Changing a Numeric Heading to Text in Excel 2007


When creating reports you might want to enter the year numbers as headings above the figures:

To prevent the headings from being treated as numbers, change them to text:

Enter the apostrophe symbol before the number.