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
Sandy - 25 Aug 2006 14:25 GMT
Mary
Highlight the range Click edit then Go To and then special then check blanks
Then enter 0 and ctrl + enter
Hope this helps!
> 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