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

On Thu, May 15, 2008 at 6:36 AM, Don Daugherty <[EMAIL PROTECTED]> wrote: > WANG, Xiaoyun wrote: > >> 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

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

In Format | Cells | Numbers select "User defined" in the Category and then in the Format Code type #K or #M or #B Obviously you can show varying numbers of decimal places by replacing # with #.# (1 dec place) or #.## (2 dec places) etc. Neil Don Daugherty wrote: WANG, Xiaoyun wrote: Hi, gur

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

WANG, Xiaoyun wrote: 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. Unless there is a format code somewhere that does it (I haven't found one,) the o

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

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