MS Excel: Convert a text to a number
- Joel Lipman
- Excel
- Hits: 5983
This is a quick article on how to convert some cells in Microsoft Excel to number values...
Why?
OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel stop understanding what a NUMBER was?
I have a column full of currency values which I want to convert, specifically Philippine pesos to British pounds (sterling). When I multiply the Philippine peso by the conversion rate, it returns #VALUE!
How?
The problem is that I have a column which includes the currency symbol as per the following image: