View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default excel format question

Click TOOLS in the menu and select OPTIONS.

In the OPTIONS dialog box remove the checkmark from the ZERO VALUES checkbos
in the WINDOW OPTIONS panel near the bottom.
--
Kevin Backmann


"carl43m" wrote:

I have a column of information. Generally their is an alphanumeric name in
most of the rows. However, on occasion there is nothing in the row and a
zero appears. I am trying to understand how to make the cvell just be blank
rather than the number zero showing up. In allother instances the
alphanumeric data in any of the rows is ok. Thanks.