» Removing Hidden Apostrophes from Imported Numbers
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Column B contains an imported list of numbers.
All the numbers include a leading apostrophe.
Excel interprets such values as text. They are unable to be formatted as currency, nor can they be used in calculations such as SUM and AVERAGE.
We, therefore, want to remove the apostrophe from each of the values in column B and convert them to normal numbers.
Solution:
Use the VALUE function as shown in the following formula:
=VALUE(B2)
Book Store:
Recommended Books:
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Understanding Financial Statements
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Special Edition Using Microsoft Excel 2002
No comments have been submitted.

