excel 2002 convert numbers to mathematical

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,706
Office Version
365, 2010
Platform
Windows, Mobile
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?

 

anon125

Active Member
Joined
Feb 14, 2008
Messages
365
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

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,706
Office Version
365, 2010
Platform
Windows, Mobile
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

Active Member
Joined
Feb 14, 2008
Messages
365
it turns out that the - were not minuses!
i found and replaced them with real - and it works
thanks
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,706
Office Version
365, 2010
Platform
Windows, Mobile
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
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,978
Messages
5,471,792
Members
406,787
Latest member
abringley1083

This Week's Hot Topics

Top