How to replace a repeated balance with a symbol

J

Joe T

I have this formula in a cell G53: =SUM(G52,-E53,F53). It works fine.
However, it shows the same balance until I input a new entry on the empty
line. How can I hide ( replace ) the balance with a symbol like -
I am using MS Office 2007 Excel.
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PLEASE HELP??? copy every other cell value to a range of cells 3
How to put Zero in a cell 6
Hiding values in cells 1
How do I create a click on + symbol to open a root and click on -. 1
How do I eliminate a symbol? 1
How to set up a formula that it adds value on a certain date 5
Report/Subreport balance forward 2
how to find and replace a symbol in my worksheet 3

Top