Search:

Type: Posts; User: jaqcues; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    6
    Views
    287

    Re: Custom number formatting in Excel

    Whoops, had to tweak 2nd and 3rd point

    1 apply custom number format as in post#1
    Range Number Custom Format: [=0]"N/A";[<1]#0.0%;###%

    2 add NEW CF rule (to insert + before positive numbers)...
  2. Replies
    6
    Views
    287

    Re: Custom number formatting in Excel

    Hi all,

    Thanks for your replies!



    :confused:
  3. Replies
    6
    Views
    287

    Custom number formatting in Excel

    Hi there,

    Im trying to display some tricky % number formatting and have hit a dead end. Just wondering if it's possible to display % under the following criteria

    Over 100%: +xxx%
    0-100%: ...
Results 1 to 3 of 3