Excel Number Format

[Siops]

Hello. My current format shows "K" for each numbers. I'm just wondering if it's possible to put a conditional setup that if the value is below 1000, it will show the actual number format?

For example -- number value is 9000, my current format it will show as 9K -- but if the value is 900, it should show as 900 instead of 0.9K. Appreciate the help!

 

[RoryA]

Do you have negative numbers to deal with too?

 

[Siops]

Do you have negative numbers to deal with too?

Hello. No negative numbers.

 

[RoryA]

Then you can use a custom number format like:

[>=1000]0.0,k;0

 

[Siops]

Then you can use a custom number format like:

[>=1000]0.0,k;0

This works! THanks a lot

 

[RoryA]

Glad we could help.