» Removing Hidden Apostrophes from Imported Numbers
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem: 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:
- Microsoft Excel Version 2002 Step by Step
- Microsoft Excel VBA Programming for the Absolute Beginner
- The Financial Numbers Game: Detecting Creative Accounting Practices
- The Interpretation of Financial Statements
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
No comments have been submitted.
