Rounding

[Jerome Alper]

I have a spreadsheet that has several tabs with some
columns of whole numbers, I would like to round these
numbers to millions with either formatting or a function.

Example:
I would like to format the numbers from
$6,236,897 to be $6.2

Can this be done easily, without adding additional columns
to all the tabs?

Thank you

 

[Bernie Deitrick]

Jerome,

Use a custom number format of

$#.0,,

HTH,
Bernie