Posted to microsoft.public.excel.programming

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert string to integer	eugene	Excel Programming	7	February 20th 07 07:00 PM
Varaibles as both integer and String	RominallL	Excel Programming	5	January 31st 07 06:33 PM
String or integer?	JustinP	Excel Programming	2	September 5th 06 06:56 AM
Compare string with integer	hurriance[_8_]	Excel Programming	2	June 26th 06 09:14 AM
Concatenating a string and an integer	[email protected]	Excel Programming	2	April 5th 06 07:40 PM

All times are GMT +1. The time now is 08:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us