TRIM OR TRUNCATE FUNCTION FOR 1000+ RECORDS

[Roadmap]

I have a 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 using the vba
module?

Thanks!

 

[tina]

cells? sounds like you're working in MS Excel; if so, suggest you post your
question to an Excel newsgroup. this ng answers questions about modules, dao
and vba coding in MS Access relational database software.

 

[Roadmap]

Thank you Tina - I have joined the Excel group and posted the message.
Good evening.