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

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
 
J

joeu2004

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"
 
D

Dave Peterson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Number Format for text 8
Indent and format based on Col A 4
convert number to % using only custom number format challenge 7
Custom number format thousands and zeros as "-" 1
Custom number format 4
custom number format not working 2
Format Reporting Numbers to Thousands 4
Format a number as ppm 7

Top