Hi

The cell may have special formatting properties to show - rather than 0. Go
to Format/Cell and set to General.

Andy.

"jrabs12" wrote in
message ...

I am sorry, I figured out the problem. I have made the corrections and
the MAX formula is working well. It changes accordingly when i change
my current stock price. Yet, I am experiencing a certain problem still,
Instead of displaying a "0" it is just displaying a "-" how do i change
this?????


--
jrabs12
------------------------------------------------------------------------
jrabs12's Profile:
http://www.excelforum.com/member.php...o&userid=37194
View this thread: http://www.excelforum.com/showthread...hreadid=569032