TRIM OR TRUNCATE FUNCTION FOR 1000+ RECORDS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roadmap - 07 Jan 2007 02:59 GMT

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!

Reply to this Message

tina - 07 Jan 2007 03:30 GMT

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.

> I have a worksheet with +1000 records with 10 columns across. I can
> display the numbers in each cell by selecting "format cells, number,
[quoted text clipped - 4 lines]
>
> Thanks!

Reply to this Message

Roadmap - 07 Jan 2007 04:16 GMT

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

> 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
[quoted text clipped - 8 lines]
> >
> > Thanks!

Reply to this Message