Awesome - thank you. It worked. Love this site. Have a great day.
Jennifer
"Sandy Mann" wrote:

Try highlighting all cells and selecting the Number format to show the
number of decimal places that you want, then select:

Tools Options Calculation Preceision as displayed

Always try anything new on a COPY of your spreadsheet first.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Jennifer" wrote in message
...
I am looking for the formulas to truncate the entire spreadsheet. I know
how
to trunc a cell, but it is manual and time consuming. Is there a general
formula you can apply to the entire spreadsheet? Thank you -