Re: Trim numbers to x decimal places

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 12:24:58 GMT

Hi Andrea,

Check the ROUND or TRUNC function. 

-- 
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <214801c3fc61$23bbbfc0$a501280a@phx.gbl>, 
anonymous@discussions.microsoft.com says...
> Help please !!!!
> 
> I am trying to write some code that will trim general 
> numbers.
> 
> e.g. 123.123456789 to 123.1234
> 
> I have looked at Trim Statements but these only seem to 
> apply to characters and spacing.
> 
> Thanks Andrea
>

Relevant Pages