Convert any number into Thousand format simply making some modifications.
Select Data - Press Ctrl + 1 - Format cell will open up - Go to Custom - Delete General & Type 0.00, "K"
--------------------------------------------------------------------------
0.00, "K" = (Zero)(Period)(Zero)(Zero) (Space) (inverted commas)(letter K)(inverted commas)
-------------------------------------------------------------
I upload Excel related tips & shortcuts which can save your time while working on the Excel sheet. I also upload tutorials in English & Hindi to understand the formula with some basic examples.
Contact Me :-
Email - [email protected]
Telegram - https://t.me/+UAVHfg7OMBk5M2M1