• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Custom Formatting for Percentage and Number in a common cell.

G

goingagain1

New Member
Hi All,

I am looking for a custom format which can show value in number or Percentage depending upon the slicer choice. can you please help me with the syntax which I can use for custom format in excel.
 
Conditional formatting will change the number format provided you can get your slicer to return TRUE/FALSE according to the selection.
 
you can use Custom Number format in certain circumstances
eg: to Display % if less than 100% and Numbers if greater than 100%
use: [>1]#,##0.00;[<1]0.0%;0
 
You must log in or register to reply here.
Back
Top