MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formating cells


Posted by Steven Faith on September 14, 2000 8:08 AM

I have a report that is populated with large numbers and would like for the last three digits to be chopped off and report in thousands, does anyone know how to do this with out creating additional cells and code.

example

23,456 to 23


Posted by Tim Francis-Wright on September 14, 0100 9:03 AM

Change the number format for the cells that
need this treatment to:
#,##0,

This will round everything to the nearest
thousand, without changing the actual numbers
in the worksheet.

HTH