View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike NG Mike NG is offline
external usenet poster
 
Posts: 87
Default 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