Format to Thousands and x-foot the sum

J

Jeanne

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?
 
G

Gordon

Jeanne said:
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?
Click to expand...

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.
 
Top