Need help with TEXT formula

[greykitten]

Hello,
I'm trying to take the difference of two values, divide that answer by 1000 to make the answer more readable and add a "K" to the end of the number to denote the number being in thousands. The answer should look like "$88K". Here is a general example of what I'm trying to produce. I don't know if I should use a TEXT formula or CONCATENATE. Can anyone help me with what the easiest way would be to write this?

G43=$2,091,616
D43=$2,003,568

=(G43-D43)

Thank you in advance!
GK

 

[NARAYANK991]

Hi ,

You can use a cell format as follows :

$ .#0, K

This will retain the value as it is , but display it in the format you want.

Narayan

 

[greykitten]

Thanks Narayan. That format produces "$88.05K" when I try it. What would I change the custom format to since I just want "$88K"? What if I wanted "$88.1K"? I tried adjusting the custom format but I couldn't get it down to just "$88K".

Thanks again!
GK

 

[Luke M]

Remove the 0's after the period.
If you had value
456,123
a format of:
$0,K
would produce:
$456K

A format of:
$0.0K
would produce:
$123.5K

 

[greykitten]

Thanks so much Luke!