Money values in terms of K

[#1]

Hi All,

I wanted to display money in terms of K.

Ex: I have data like this 1000000 should be represented as 1000k

can anyone suggest how to do this? or any better alternative since number of zero's creates confusion

Regards,

Prajna

[israrkhan]

where you want to display, in which control..

if you want to display in chart.. see the image below..

On Number tab, right >> down..

[#3]

hi,

I want to achieve in gauge chart...

I tried this it didn't work out

Regards,

Prajna

[israrkhan]

Use like below:

=Num(YourExpression / 100,'##.##K')

are you showing this in "Text in Chart" or ???

[#5]

hi,

Its nothing but min and max value in the gauge..

As shown in the above attached image.. wecan see some values rite? so that is the values given in as below

[israrkhan]

Hi,

On Number tab, set it fix to 0, and add K, see image

Result Below, But dont forget to Devide your Expression by 100

[israrkhan · Accepted solution]

Here you go, Very simple...

Just use  this in Max 10000/1000 and K in Number Tab....

[#8]

Thank you

Regards,

Prajna

[israrkhan]

was very simple, but you did not explain it first, as you show image in last post.

any way...