rounding

J

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
 
R

Ron Rosenfeld

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


Custom Format: $#,,.0


--ron
 
Top