I'm trying to make a formula for calculating Return on Investment.
Which is equal to (total revenue-total expense)/my investment
My formula right now is =(D18/D4)*100
D18 is (total revenue-total expense)
D4 is my investment

But the output is in $ format
How do I make it as a percent?


--
Amuse
------------------------------------------------------------------------
Amuse's Profile: http://www.excelforum.com/member.php...o&userid=25086
View this thread: http://www.excelforum.com/showthread...hreadid=385986