lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I want to add K or M to numbers, for example 1000 i want it this way 1K and 1000000 i want it 1M.
So for 1K I did this custom formatting
#; \K
It did work find in the number is 1000 and above but if the number is less than 1000 then excel will put K. Is it possible to remove K when the number is less than 1000?
I want to add K or M to numbers, for example 1000 i want it this way 1K and 1000000 i want it 1M.
So for 1K I did this custom formatting
#; \K
It did work find in the number is 1000 and above but if the number is less than 1000 then excel will put K. Is it possible to remove K when the number is less than 1000?