Hello,
I have a column I formatted to have K and M for thousands and millions. So 1,000 would be 1k.
I used this formula in the format cells-custom:
[>=1000000] $# ## 0.0,,"M";[>=1000] $ # ## 0.0,"K"; # ## 0.0
Now I need to add that to a text in the next column, but it doesn't keep the formatted cells (using & formula).
So if I have a text "Deal size:" I want to add it to the 1k to get:
Deal Size: 1k
Right now I am getting "Deal Size 1000"
How can i keep the formatted numbers when I add the text to it?
Thank you!
Bookmarks