Can excel calculate?
On Thu, 24 Jul 2003 at 03:18:29, Karl Itschen (Karl Itschen
) wrote:
Please note that C++ does it right!
So does VBA if you understand how to manipulate data types. I think C++
may use more bytes to store
Dim number, tempRound As Double
Dim tempInt As Long
Dim tempDec As Long
number = 64.111
tempRound = number
tempInt = tempRound
tempDec = (10 * (tempRound - tempInt))
Debug.Print "tempRound = " & tempRound
Debug.Print "tempInt = " & tempInt
Debug.Print "tempDec = " & tempDec
tempRound = 64.1
tempInt = 64
tempDec = 1
--
Mike
|