ExcelBanter - Set default value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Set default value (https://www.excelbanter.com/excel-worksheet-functions/107104-set-default-value.html)

Mary

Set default value

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

Set default value

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

"Mary" wrote:

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

All times are GMT +1. The time now is 10:36 AM.