Results 1 to 3 of 3
  1. #1
    5 Star Lounger ibe98765's Avatar
    Join Date
    Aug 2001
    Location
    Bay Area, California, USA
    Posts
    966
    Thanks
    19
    Thanked 4 Times in 4 Posts

    Number format question

    I have a sheet where I use this custom number format ( 0;-0;;@ ) to hide zero values in selected cells.

    It works fine, however when I enter a value in one of the selected cells, I need the cell to display 2 digits after the decimal. I cannot figure out how to modify this format to do this.

    Any help is appreciated.

  2. #2
    New Lounger
    Join Date
    Dec 2015
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try ( 0,00;-0,00;;@ )

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Leif,

    You got it except OP is in the US so it would be {0.00;-0.00;;@}
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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