Cell Formatting

  • Thread starter Thread starter Paul
  • Start date Start date
P

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