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

On Jan 26, 10:18*am, Dr. Darrell
wrote:
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


Try the following custom format:

#,##0.00,"K"