» 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:
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Special Edition Using Microsoft Outlook 2002
- Excel Charts
- Wall Street Journal Guide to Understanding Money and Investing
- Microsoft Office XP Introductory Concepts and Techniques
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
No comments have been submitted.
