View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Custom Number Format... Display 29,480 as 29.48K

hi
add this to your custom formats...

0.00, "K"

Regards
FSt1

"Dr. Darrell" wrote:

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