View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default 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