Set default value

M

Mary

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
 
S

Sandy

Mary
Highlight the range Click edit then Go To and then special then check blanks
Then enter 0 and ctrl + enter
Hope this helps!
 
Top