Did you try my custom format of $#,##,

It won't round, but gives you a couple more digits displayed.


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 10:28:08 -0700, BeveyG
wrote:

Hi Rick,

THANK YOU SOOOOOOOOOOOO MUCH. That worked.

The next problem I end up with is that the chart that I create from the data
won't reflect the millions of dollars. Because the custom number you
suggested takes the monetary recognition to a $3.78 value the chart axis
then is scaled in millions and
the chart would not recognize the number and show a column because the
number did not match the scale. I worked with the scale and still could not
get the column to appear. Any suggestions. I am working with a scale from
$0 to $8,000,000.

I appreciate any suggestion you might have as we are trying to make the
chart more legible for our client.

Have a great morning,
BeveyG


"Rick Rothstein" wrote:

Try this Custom Format...

$0.00,,

--
Rick (MVP - Excel)


"BeveyG" wrote in message
...
Hi,

I am working with a spreadsheet that has cells with dollar values in the
millions. Can I format the cells from the typical $3,775,000 to $3.77?
When
the spreadsheet is updated and a chart is created, it is difficult to read
the cells as the chart covers a 3 year period.

Thanks.