rounding

Giganews Newsgroups
Subject: rounding
Posted by:  Jerome Alper (jerome.alp…@diageo.com)
Date: Fri, 10 Oct 2003

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

Replies