Custom Number Format... Display 29,480 as 29.48K

  • Thread starter Thread starter Dr. Darrell
  • Start date Start date
D

Dr. Darrell

I would like to format some numbers with "K" to designate Thousands.

The format I would like to see is as follows:

26.125 ---> .03 K
920.20 ---> .92 K
2,920.20 ---> 2.92 K
24,920.50 ---> 24.92 K
254,920.50 ---> 254.92 K

I don't see this option in the Custom Catagory, Can you give me a clue?

Thanks,
Darrell
 
The format I would like to see is as follows:
26.125 --->  .03 K
920.20 --->  .92 K
2,920.20 --->  2.92 K
24,920.50 ---> 24.92 K
254,920.50 ---> 254.92 K
Click to expand...

Try the following custom format:

#,##0.00,"K"
 
How about a custom numberformat of:

..00,K



Dr. Darrell said:
I would like to format some numbers with "K" to designate Thousands.

The format I would like to see is as follows:

26.125 ---> .03 K
920.20 ---> .92 K
2,920.20 ---> 2.92 K
24,920.50 ---> 24.92 K
254,920.50 ---> 254.92 K

I don't see this option in the Custom Catagory, Can you give me a clue?

Thanks,
Darrell
Click to expand...
 
Back
Top