zero values
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: zero values

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a problem with zero values. I want
    a zero value, or actually the number 0.00
    to show in a cell and to be used as a number in a formula. The problem is I need the form to be "without zero values", but need this "0.00" to appear in only the one cell.

    Is this possible? Help!

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What is "the form" ?




  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-26 19:32, cpc wrote:
    I have a problem with zero values. I want
    a zero value, or actually the number 0.00
    to show in a cell and to be used as a number in a formula. The problem is I need the form to be "without zero values", but need this "0.00" to appear in only the one cell.

    Is this possible? Help!
    It's possible. Run this macro on your sheet:

    Sub HideThoseZeros()

    ActiveWindow.DisplayZeros = True
    Cells.NumberFormat = "0;-0;;@"
    Range("A1").NumberFormat = "0.00"

    End Sub

    Just replace "A1" with whatever Cell address you had in mind. You can also do this manually, but since I don't know your language packet this should do it...

    [ This Message was edited by: Sbirro Cornuto on 2002-03-27 00:34 ]

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dave Hawley, regarding zero values
    the form is simply a workbook in excel.

    Sbirro, Yes is there a way to do this manually? The language? What do you mean?
    English? Can this be done with out VBA?

  5. #5
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use Custom Formatting in the cell you wish to display the 0.00.In the dialog box, enter ";;0.00;" This will display zero as 0.00 Now enter a zero in that cell. You can turn off the display zeros for all other cells under tools options

  6. #6
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi cps


    If it's only [b]one cell[b] you want to show zero as 0.00 while all others are hidden, try:
    ="0.00"

    With the Tools>option-View-Zero values Off


    If you need the value in a Function just times by 1 first.




  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes you can do it manually, set your sheet to display zeros, select all the Cells and change the number format to 0;-0;;@, then go to the Cell you desire to Display zeros in 0.00 format and change it's number format to 0.00. I wanted to know your language packet cause I have propably the only Italiano Excel in NYC and though can't advice you step by step if you don't have that...



    [ This Message was edited by: Sbirro Cornuto on 2002-03-27 07:22 ]

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Oh yes, this is getting all nice and confusing. The main point is as follows:

    If you have the WorkBook View-Zero values turned Off, it wont so you the zero values. So you want to turn it on and then go to Sheet's Cells and change the Number Formating in those to "0;-0;;@" so they wont show zeros, except the one you want to show zeros, you change it's Number Formating to "0.00" and there you have it.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com