excel 2002 convert numbers to mathematical

[anon125]

i copied numbers from an online account.
pasted them into excel 2002.
how do i convert the numbers to numbers i can multiply etc?
i tried putting a 1 into a cell then copying and paste special multiply

tried converting the cell to numbers

thanks all

 

[anon125]

Thanks very much Mark.
will try a new file first

 

[anon125]

numbers to be converted.xls

drive.google.com

here is a link to the excel 2002 file that needs the numbers converted

thanks everyone

 

[anon125]

deleted

 

[MARK858]

See if the below is what you want (I'll leave you to format the cells as dollars). By the way didn't see any hyperlinks in that document, did you already deal with them?

numbers to be converted (1).xls | Powered by Box

app.box.com

 

[anon125]

thanks. i forgot to say to remove all those zeros that occurred when i selected all to remove the hyperlinks.
it has ended up 993 pages long! instead of 214 rows.

sadly the file does not work. i try and multiply a negative number and just get #VALUE
please try again

 

[MARK858]

numbers to be converted (1).xls | Powered by Box

app.box.com

 

[MARK858]

sadly the file does not work. i try and multiply a negative number and just get #VALUE
please try again

I have removed the zero's in the link in the previous post.
As for your value error I am afraid I have no idea why you are getting a #VALUE error when multiplying a negative number by 3 with 2002 as the numbers in the file in the link are all real numbers now (unless you had the cells in the sheet you are pasting it back into formatted as Text and not General before you did the paste).

 

[anon125]

thanks for trying.
it was just a new file i pasted them into.
i will try again.. hang on.

tobeconverted.xls

drive.google.com

 

[anon125]

it turns out that the - were not minuses!
i found and replaced them with real - and it works
thanks

 

[MARK858]

it turns out that the - were not minuses!
i found and replaced them with real - and it works
thanks

My bad, corrected it in the first file but didn't check that it was still sorted in the 2nd when I removed the zeroes, but at least you have it sorted.

Thanks for the feedback