This is still not right. The code:
CurrentValue <= 1e6, "#,0,.0K"
Displays K in cell when gou export the data to excel or use it in chart. K, M should only be shown as display texts not as part of value.