Hi Reeza,

Thanks for your response.

I attempted that yesterday, but because the number I entered in the
worksheet was 3.8 (representing 3,775,000 after using the suggested formula
of =3,775,000/1000000) 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

"Reeza" wrote:

On Sep 10, 1:08 pm, BeveyG wrote:
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.

For the Chart I know you can change the Display Unit, go under scale
and modify from one to million or some suitable data.