View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
John Read
 
Posts: n/a
Default How do I hide zero values but keep currency format in P.O. form?

On Thu, 09 Feb 2006 18:30:01 +0100, Niek Otten wrote:

ToolsOptionsView, uncheck Zero values

You might like to try:

=IF(C60,C12," ")


This simply says that if the value in, say the quantity cell (say c6) is
non-zero then display the value (e.g. C12) otherwise display nothing