Range("A1").Value = CInt(Range("A1").Value)
--
HTH...

Jim Thomlinson


"DKY" wrote:


How do I change the value of a cell to a whole number? The closest
thing I can find on the net is int and it says to do like so
int(C1)
So I tried to program that in to my loop where i is equal to the row
number
int("C" & i)
and it says to me
"Compile Error: Expected Identifier"

I'm not even sure if int is what I want to do because after doing
further research on it, it seems that int causes the value to round
down. So a value of 210.832169 will be 210 instead of 211. Anyone
have any insight on what I can search for?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=471437