On Sun, 9 Nov 2008 11:29:24 -0800 (PST), Orchid wrote:

On Nov 9, 7:02*am, Ron Rosenfeld wrote:
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

Thanks so much for your help!! It works perfect as I want.

You're welcome. Glad to help. Thanks for the feedback.
--ron