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.