Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Convert the single to an integer
#1
Solved: 6 Years, 1 Month, 4 Weeks ago
I have a function that returns a number
This number is type = single
How can I convert the single to an integer

Rand is returned a example 10 type single

The following do not work
CInt(Rand) = RandomNumberBetween(0,11)
FormatNumber(Rand) = RandomNumberBetween(0,11)
Reply
#2
Solved: 6 Years, 1 Month, 4 Weeks ago
Problem solved
I was putting the CInt in the wrong spot

Rand = CInt(RandomNumberBetween(0,11))

Working now - maybe this will be useful for someone else
Reply
#3
Solved: 6 Years, 1 Month, 4 Weeks ago
Thanks for your thoughtfulness. It will surely help others.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to convert a String into a Object vjjohnson04 1 7,060 10-26-2012, 11:14 AM
Last Post: Ankesh
  how to pass an integer array variable in a query sujaravi123 1 3,408 10-28-2011, 01:44 PM
Last Post: ravi.gajul
  Seperate integer, char and special char alias@12 2 2,900 03-24-2011, 02:23 PM
Last Post: basanth27
Smile Geting integer values from a Java Table dineshhcl 0 2,489 03-26-2010, 06:53 PM
Last Post: dineshhcl
  How to Read Multiple excel files and save data in single excel sheet upadhyay40 6 15,706 12-03-2009, 09:53 AM
Last Post: Saket

Forum Jump:


Users browsing this thread: 2 Guest(s)