How do I format cells to round to the nearest thousands without ..
 

using the Round Function. It seems like there should be a way to format
numbers that are already entered into cells.Thanks!

On Wed, 16 Mar 2005 09:55:03 -0800, "excel user" <excel
wrote:

using the Round Function. It seems like there should be a way to format
numbers that are already entered into cells.Thanks!

You can format the numbers -- this will not change their values. In other
words, 23,501 can be formatted to look like 24 or 24,000. However, the value
in the cell will remain 23,501 and will behave as such in calculations that
reference the cell.

To format 23501 as 24:

Format/Cell/Number/Custom Type: #,

To format 23501 as 24,000

Format/Cell/Number/Custom Type: #,",000"


--ron