TRIM OR TRUNCATE FUNCTION FOR 1000+ RECORDS

[Roadmap]

I have a Excel worksheet with +1000 records with 10 columns across. I
can
display the numbers in each cell by selecting "format cells, number,
decimal places 1". However, the cells contain calculated values with
as many as 10 decimal places each. How can I "truncate" or "trim" the
values to display as well as round to 1 decimal place automatically
(perhaps with the vba module)?

Thanks!

 

[Jim Gordon MVP]

Hi,

Excel has several cell formulas that accomplish round functions.

First, be sure that the analysis tool pak is turned on (Tools > Add-ins).

Then check Excel help and search for ROUND worksheet function. You should be
able to incorporate the desired behavior into the calculations.

If this answer doesn't completely answer the question, if you could post a
follow-up message that has the calculations (cell formulas) you're currently
using we might be able to offer some specific examples to use.

-Jim Gordon
Mac MVP

I have a Excel worksheet with +1000 records with 10 columns across. I
can
display the numbers in each cell by selecting "format cells, number,
decimal places 1". However, the cells contain calculated values with
as many as 10 decimal places each. How can I "truncate" or "trim" the
values to display as well as round to 1 decimal place automatically
(perhaps with the vba module)?

Thanks!

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info