Question regarding Google Spreadsheets?

Edit: Solution found.

 

Bump.. I know there were other threads linking to google spreadsheets..

I just need a function/format that removes text from a cell but leaves number and then I can adjust it to be 1000 or 1000000 times greater.

Or a different link to import from

 

If you just need to remove the m from the end, just use =left(A1,Len(A1)-1)

Where A1 is the cell containing the 1m or whatever.

That what you were after?

 

Thank you, no longer needed I used the rs wiki page to import from thank you though.

 

Wrong section anyways? If you're making skilling spreadsheets, google 'thunder xp apreadsheets', that's your competition. They update to the g.e and the lot.

 

Thanks posting this, I'm going to check it out.