Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.

Finally, using Excel's built-in Currency and Accounting number formats gives you the confidence that all financial data is formatted consistently across your spreadsheet, Excel's calculations will ...