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

How about a custom numberformat of:

..00,K



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


--

Dave Peterson