Zero Values in Excel

  Dirk Diggler 19:15 20 Aug 04

An appeal to any Excel wizzo's out there!

I have a simple sum ie, a1:a10 in a cell

If that value is zero, how can I get it to leave it blank?

  VoG II 19:18 20 Aug 04


  clm2 19:24 20 Aug 04

Or Tools>Options>View>Windows Options and clear 'Zero Values' box

This thread is now locked and can not be replied to.

Microsoft Surface Studio PC release date, pricing, design, features and spec: Microsoft showcases…

1995-2015: How technology has changed the world in 20 years

This amazing app turns your iPad Pro into a Cintiq

Apple Q4 2016 financial results | Apple earnings report: iPhone, iPad and Mac sales down, profits d6…