Can anyone help? I have got a spreadsheet with information I have imported from the web. I want to do a simple sum of =g/e but because the imported information is in dollar form when I put the formula in it will not let me do the sum. If, however, I change every individual cell to numbers manually then I can do the sum. Is there any way i can change the cells to numbers any other way than doing each one individually?
BTW I have tried selecting the whole column and formatting cells to numbers but to no avail.
Book1.zip
Forgot to add this to show you what I mean.
Bookmarks