A visitor wrote

I am taking a refresher finance course and I am trying to analyze two companies (file of data from googlefinance attached). Here is my problem:

I would like to analyze a couple of companies and I downloaded the financial statement analysis of both companies into Excel. However, when I try to manipulate the date I get a return of: #VALUE.
I found out that this happens because of some programming in the Googlefinance data into Excel.

I would appreciate it if anyone has an experience with this formula if they could tell me how to use it.

It would be great if you could answer it! Thanks for anything you my be able to do. 

You can try the following formula assuming the number you want to manipulate is in cell B4

=VALUE(MID(B4,2,LEN(B4)-2))

The problem is that you have a space before and after each number and excel sees the number as a word and not a number. Hope this helps

This should work.