Thread: I want Excel to regard emply cells as zero and display it
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default I want Excel to regard emply cells as zero and display it
Another method..........

Select the range.

F5SpecialBlanksOK

Type 0 in active cell then hit CTRL + ENTER


Gord Dibben MS Excel MVP

On Mon, 25 Dec 2006 11:43:01 -0800, Teethless mama
wrote:

Select your range then go to menu Data Filter AutoFilter Blanks enter
all 0

"gencerm" wrote:

on a selected area in the worksheet.

Reply With QuoteReply With Quote