format = cells = Number Tab, select custom

use ;;;
for the format.

--
Regards,
Tom Ogilvy

"gavmer" wrote in message
...

Hi all,

Small problem. Have a formula in a cell =a1*g1. Problem is I dont want
the value when selected to show. I would accept the cell showing "Inc"
or even changing colour but the value cannot show as it is a price.

Can anyone please help??

Cheers!!!


--
gavmer
------------------------------------------------------------------------
gavmer's Profile:
http://www.excelforum.com/member.php...fo&userid=6662
View this thread: http://www.excelforum.com/showthread...hreadid=262249