Prev: minutes
Next: Which criteria was matched?
From: Flipper on 18 Feb 2010 11:21
How can I format 31,840,000 to appear as 31.84M, and or 35,000,000 as 35M?

Thanks
--
Allan
From: מיכאל (מיקי) אבידן on 18 Feb 2010 11:45
You may try this: 0.##,,"M"
Micky


"Flipper" wrote:

> How can I format 31,840,000 to appear as 31.84M, and or 35,000,000 as 35M?
>
> Thanks
> --
> Allan
 | 
Pages: 1
Prev: minutes
Next: Which criteria was matched?