|  

» Changing a Numeric Heading to Text

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.
• For example, '2003 will be treated as a text entry.

• Note: the ' (apostrophe) symbol is not visible in the cell.
Screenshot // Changing a Numeric Heading to Text
Changing a Numeric Heading to Text

Rate This Tip
12 34 5
Rating: 2.76     Views: 29131
How to handle number as text in .csv files
Spockadini  Posted on: 31-12-1969
Hi,
I have a problem trying to exchange data by a .csv format. I have a TEXT record and when data are numeric excell treated it as numbers. Is it possible to set format to text in the .csv files?
Name
Comment Title
Comments