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
|