Custom Number Formatting

[StarMusk10]

Hi all,

I'm trying to figure out how to use custom formatting of a number to show "No Change" from the previous entry. This is what I'm using for the Increase and Decrease, [Red]▲ 0;[Color10]▼ -0. What I want to do is add a "No Change" part to this. Right now if there is no change to the number from the previous entry it will show a ▲ 0.

Let me know if you need more information.

Thank you all!

 

[herofox]

pls up the file and explan in the file which you want

 

[StarMusk10]

herofox,

Thanks for the response. Here is the example you requested.

 

[herofox]

here you are

 

[Peter Bartholomew]

… or with the number hidden.

 

[Chihiro]

You can simply change your Custom Format.
[Red]▲ 0;[Color10]▼ -0 ; -

In Custom formatting. Semi colon is used to denote following by position.
POSITIVE; NEGATIVE; ZERO; TEXT

 

[StarMusk10]

Thank you herofox, Peter, and Chihiro for the help. Problem Solved!!