Cell Formatting

[Paul]

Is there a way to format a cell so that it will
automatically round either up or down?

I am currently using Excell 2002.

Thanks

 

[MOSHE]

format "number" seems to work just fine
Moshe

 

[JON-JON]

Paul,

Is this what you need? This will not limit you in just rounding decimal
places.

Format>>Cell>>Number>>Custom

To make 1,234,567.00
as 1,125 type #,##0,
as 1,1234.57 type #,##0.00,

You can try other formatting just try it. Please note that this formatting
will only change the way you see the number is displayed on the screen but
does not change the actual value.

Hope this could help.

Jon-jon