Format to Thousands and x-foot the sum
 

For Finance Department - internal purposes, we have a balance sheet printed
to the penny. For Board of Directors, we need to omit the hundreds. How do
I switch the sheet to only display the thousands and have the x-foot total
tie out in thousands?

"Jeanne" wrote in message
...
For Finance Department - internal purposes, we have a balance sheet
printed
to the penny. For Board of Directors, we need to omit the hundreds. How
do
I switch the sheet to only display the thousands and have the x-foot total
tie out in thousands?

Format Cells - Custom Format and use #, as the format. Do NOT omot the
comma! This will actually round up to the nearest thousand, so you might
have the odd rounding difference.