Custom Number Formatting with percentages

[Chakra]

Hello to all,

I have searched numerous sites and cant seem to be able to finalize the percentage format.
What I want is to convert either >999.99% to 1k% or <-999.99% to -1k%.
So for instance, if the result is either -3125% or 3125%, how would I include this code in one string if I wanted to show (3k%) for the negative result and 3k% for the positive one, and of course regural formatting for the between -999.99% to +999.99%?

The closest that I got was [>-10]General;[>10](#0,%"k");#0,%"k"

Thank you so much for your feedback.

 

[Hui]

Try:
[<-10](#0,%"k");[>10]#0,%"k";#0%"k"

 

[Chakra]

Hey Hui,

Thank you for your feedback once again....
This surely covers the range below -999.99% and over 999.99%.
However, what about the in between percentages, for instance 115% or 95% or even 501%, can these appear "normally" without any alterations?
Therefore the final part of my question is if we can throw an additional criterion to cover the formatting of these numbers....

 

[NARAYANK991]

Hey Hui,

Thank you for your feedback once again....
This surely covers the range below -999.99% and over 999.99%.
However, what about the in between percentages, for instance 115% or 95% or even 501%, can these appear "normally" without any alterations?
Therefore the final part of my question is if we can throw an additional criterion to cover the formatting of these numbers....

Hi ,

In the format string :

[<-10](#0,%"k");[>10]#0,%"k";#0%

the first part , colored red , covers those values which are less than -999,99%.

The second part , colored blue , covers those values which are greater than +999,99%.

The last part , colored green , covers all values in between these two outer limits.

Narayan

 

[Chakra]

Sparkling!
Works like a charm and now I know the structure behind it!
Thank you so much!