Tricky number formatting
On Tue, 13 Jun 2006 11:59:01 -0500, JeffreyO
wrote:
I don't know if this is even possible, but I'm building a spreadsheet
that requires salary data in thousands rounded to nearest hundred (e.g.
$53,817 = 53.8) I've got approximately 1400 employees on the report so
I don't really want to do each one "by hand." Is there a way to format
this?
If you want to retain the "real number" of 53,817, you could use the custom
format:
Format/Cells/Number/Custom Type: #.0,
--ron
|