• 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.

    Viewing 1 reply thread
    Viewing 1 reply thread
    Reply To: Number format question

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: