On Sun, 9 Nov 2008 00:05:40 -0800 (PST), Orchid wrote:

Hi,
I try to format a numerical value in Million. But I don't want to use
the number to divide by 1,000,000. Is there any way which I can just
use a format function? (i.e.: 12,666,678 ---- 12,7)
Your help is greatly appreciated! Thanks in advance!

You can't get quite what you've written, but you can get 12.7 (where "." is
the decimal symbol) using the format:

#0.0,,

If you want to add and M to the end, then use:

#0.0,,\M

--ron