Set default value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
How would one set a field to 0 when the field is blank without overwriting
any current values in the range? Thank you in advance, and Happy Friday.
Mary
 
Mary
Highlight the range Click edit then Go To and then special then check blanks
Then enter 0 and ctrl + enter
Hope this helps!
 
You must log in or register to reply here.

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

How to customize defaults in Pivot Table Values 1
problem with date in the VBA macro 0
How do I put a blank value in a cell not using "" in a formula 2
Return Top values with changing criteria 18
Setting Up a Series of Formulas 9
Counting NON-Blank fields 2
Excel VBA 1
formula finds values in apparently blank cells 1

Back
Top