[users] OpenOffice Calc - Convert Number to K/M/B

[WANG, Xiaoyun]

Hi, gurus,

Is there an easy way to convert a number in a cell to a rounded value with
suffix of 'K', 'M', 'B'?
For example: 1,000 -> 1.0K; 1,111 -> 1.1K; 1,234,567 -> 1.2M

Thanks in advance.

-- 
WANG, Xiaoyun
Shanghai, China