If they are constants,

format them to display as you wish

then do Tools=Options, go to the calculated tab and click Precision as
displayed.

You will be warned about a permanent loss of precision. Say OK.

Now you can change it back.

Your data should now have only the required number of decimals.

If theyare not constants, select all cells, do edit=copy, then edit=Paste
special and select values. This will replace all formulas.

--
Regards,
Tom Ogilvy


"James" wrote in message
oups.com...
Perhaps rounding the number in cell can help out? Thx. James