Re: Excel 3.0 and zeroes

Article View: comp.sys.mac.apps

Article #1142

#1142

From: Jon Udell
Date: Thu, 06 Aug 1992 12:14

18 lines
1471 bytes

>> I have tried and tried to put just one zero in a cell but it does register. 
>> Does anybody know how to put one zero in and have it stay?  Much obliged for
>> the help.      

> Check the "Display..." option under the "Options" menu, and make sure
> that you have "Zero values" turned on (i.e., there should be an "x" in
> that box).

Or, set the Number Format of the cell to 0;-0;0.  The last "0" forces
zeros to be displayed with at least (in this case always) one digit.

--
-------------------------------------------------------------------------------
Jon Udell
NCR Microelectronics Products Division      Jon.Udell@FtCollinsCO.NCR.COM   
2057 Vermont                                uunet!ncrlnk!ncr-mpd!ncr-fc!jonu
Fort Collins, CO 80525                      (303) 223-5100 X431 
-------------------------------------------------------------------------------

Technical Details

Message-ID: <JON.UDELL.92Aug6131446@salieri.FtCollins.NCR.com>

Path: arc1-ca.pugleaf.net!sparky!uunet!psinntp!ncrlnk!ncr-mpd!Jon.Udell

References: <1992Aug4.114058.1@jaguar.csc.wsu.edu> <1992Aug4.204045.1@vms.ocom.okstate.edu>

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!psinntp!ncrlnk!ncr-mpd!Jon.Udell
From: Jon.Udell@FtCollins.NCR.com (Jon Udell)
Newsgroups: comp.sys.mac.apps
Subject: Re: Excel 3.0 and zeroes
Message-ID: <JON.UDELL.92Aug6131446@salieri.FtCollins.NCR.com>
Date: 6 Aug 92 12:14:46 GMT
References: <1992Aug4.114058.1@jaguar.csc.wsu.edu>
 <1992Aug4.204045.1@vms.ocom.okstate.edu>
Sender: uucp@ncr-mpd.FtCollins.NCR.COM
Reply-To: Jon.Udell@FtCollinsCO.ncr.com
Organization: NCR Microelectronics, Ft. Collins, CO
Lines: 19
In-reply-to: churchwell@vms.ocom.okstate.edu's message of 5 Aug 92 02:40:45 GMT

Reply to Parent Message