Hide font in formula

Hide font in formula

Post by gavme » Thu, 23 Sep 2004 10:20:35



Hi all,

Small problem. Have a formula in a cell =a1*g1. Problem is I dont wan
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!!
 
 
 

Hide font in formula

Post by Tom Ogilv » Thu, 23 Sep 2004 10:38:48

format => cells => Number Tab, select custom

use ;;;
for the format.

--
Regards,
Tom Ogilvy



http://www.yqcomputer.com/

 
 
 

Hide font in formula

Post by gavme » Thu, 23 Sep 2004 10:53:02


HI Tom,

Thanks for the reply. Prob is, this shows no value. The user inputs a
qty in G1 which returns a value to b1, based on a price in a1. I dont
want the user to see the end value but would like something to show
that a value exists. If nothing, then nothing shows. Maybe code that
states if the cell value is >1, then the cell colours????

Thanks Tom!!!


--
gavmer
------------------------------------------------------------------------
gavmer's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/
 
 
 

Hide font in formula

Post by Tom Ogilv » Thu, 23 Sep 2004 11:21:45

if b1 has a value and I want to see it, I can go to another cell and do

=B1

If you want to color the font or the color, use conditional formatting.

--
regards,
Tom Ogilvy



http://www.yqcomputer.com/
 
 
 

Hide font in formula

Post by gavme » Fri, 24 Sep 2004 08:40:56


Hi Tom,

The easiest solutions are often forgotten. Thank you very much!!

Cheers!