Re: Is there a way?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 05/17/04 

Date: Mon, 17 May 2004 22:03:27 +0200

Hi
click on the 'Special' Button in this dialog 

-- 
Regards
Frank Kabel
Frankfurt, Germany
Dan wrote:
> F5 just allows me to GOTO.  I don't see a way to format blank cells
> with a zero.  BTW I am using Excel 2003.
> 
> Dan
> 
> On 5/17/2004 2:43 PM, Frank Kabel wrote:
> 
>> Hi
>> try the following:
>> - select your range (with values and blanks)
>> - hit F5, click 'Special' and choose 'Blank cells'
>> - enter a zero and hit CTRL+ENTER
>> 
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>> 
>> 
>> Dan wrote:
>> 
>>> to have Execl put a zero in a cell if it is blank?  I have a bunch
>>> of sales data but some cells had no sales so they are blank.  I
>>> want to have them zero.
>>> 
>>> TIA,
>>> Dan

Relevant Pages

  • Re: Or Statement?
    ... The formula should never return a zero. ... Those cells will ... >Hi Tony ... >Frank Kabel ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Is there a way?
    ... > Dan wrote: ... >>to have Execl put a zero in a cell if it is blank? ... >>sales data but some cells had no sales so they are blank. ...
    (microsoft.public.excel)
  • Re: SUMS with Blanks and Zeros
    ... I'd use Peo's solution (using COUNTBLANK for ... In this case a blank cell is shown as result and not a zero. ... >> AVERAGE will skip real blank cells. ... >> Frank Kabel ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Or Statement?
    ... >Hi Tony ... >Frank Kabel ... >> The formula should never return a zero. ... Those cells ...
    (microsoft.public.excel.worksheet.functions)
  • Re: I need to COUNT data greater than zero, but count if is not working!
    ... Frank Kabel ... Razaman wrote: ... > I'm trying to count cells that have numbers greater than zero. ...
    (microsoft.public.excel.worksheet.functions)