In this article, we ill learn how to remove hidden apostrophes from imported numbers in Microsoft Excel 2010.
While importing data from internet or any software, the numbers include leading apostrophe. The numbers with apostrophe are considered as text in Excel.
These numbers can't be formatted as Number, Currency, Percentage, Date, Time, etc. They are also can't be used in calculations such as SUM or AVERAGE because of their text format. Functions will not work on text format unless they are converted to numbers.
We will use VALUE function to convert text into numbers.
Value: Converts a text string that represents a number to a number
Let us take an example how to remove apostrophe from cells:
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.