Re: Displaying Leading Zeros in Cell

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 08/03/04 

Date: Tue, 3 Aug 2004 08:23:44 -0700

Right. I use Frank's tips often, but now I understand the
reasoning behind that "zero values" checkbox. Thanks!

>-----Original Message-----
>Hi
>
>just to follow on from Fred's suggestions, the reason
that ticking the "zero
>values" on the Tools, Options, View tab didn't do
anything as its purpose is
>to supress or display cells where there is only a 0 in
the cell not the way
>you wanted it.
>
>Cheers
>JulieD
>
>
>
>"Frank Kabel" <frank.kabel@freenet.de> wrote in message
>news:uofIWuWeEHA.3124@TK2MSFTNGP09.phx.gbl...
>> Hi
>> some ways:
>> - format the column as 'Text'
>> - enter the account numbers with a preceding '.
e.g. '012345
>> - use a custom format like
>> 00000
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>>
>>
>> sslates wrote:
>> > I am trying to create a column of account #s, of which
>> > many have leading zeros. I made sure that the "zero
>> > values" is checked on the Tools, Options, View tab
but I
>> > still don't see the 0s. I have a workaround (maybe
it's
>> > the correct fix??) of just formatting the column as a
text
>> > column, but I don't understand why checking the zero
>> > values checkbox doesn't work.
>> >
>> > Thanks much.
>
>
>.
>

Relevant Pages

  • Re: This Weeks Finds in Mathematical Physics (Week 240)
    ... The Poisson distribution with expected value zero clearly ... so that ``such reasoning does pay off.'' The only other ... (This was in the Electronic Journal of Combinatorics. ...
    (sci.math.research)
  • Re: Non-zero gaps between real numbers
    ... > - since there are no two different real numbers with zero gap between ... There is no reason why we should abandon this reasoning. ... If we're doing mathematics, ...
    (sci.math)
  • Re: Accept H0, or fail to reject?
    ... that it is 0 is usually zero. ... statisticians cannot understand the simple reasoning, ... zero, usually growing with the absolute value of mu. ... Herman Rubin, Department of Statistics, Purdue University ...
    (sci.stat.math)
  • Re: Evaluating the limit
    ... What I fail to understand in their reasoning is ... zero but |2x + 1| for values greater than zero? ... these points because the absolute value functions change ... Kyle Czarnecki ...
    (sci.math)
  • Re: How to destroy Leopard/Vista/Dragon, all at one fell swoop
    ... That should just be zero by your reasoning. ... thirteen minus the sum of five and eight ...
    (comp.sys.mac.system)