View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default String to Rounded Integer

On Wed, 11 Jun 2008 11:21:01 -0700, StumpedAgain
wrote:

Now that I think about it, it would be best to convert it to an integer so
that I can round. Thanks!


If you convert it to an integer, you will lose everything after the decimal!
And Integer variables are stored as 16-bit (2-byte) numbers ranging in value
from -32,768 to 32,767. This may be limiting.

See Gary's solution.
--ron