» Changing a Numeric Heading to Text
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Windows XP for Dummies
- Absolute Beginner's Guide to Microsoft Excel 2002
- Investing in Real Estate, Fourth Edition
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
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?