Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
"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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to add/remove characters over thousands of cells | Excel Discussion (Misc queries) | |||
How do i format a 5 to 6 digit number into the correct date? | Excel Worksheet Functions | |||
Sort of format Question | Excel Worksheet Functions | |||
How do I format cells to round to the nearest thousands without .. | Excel Discussion (Misc queries) | |||
Problem with txt format | Excel Discussion (Misc queries) |