View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric[_24_] Eric[_24_] is offline
external usenet poster
 
Posts: 1
Default truncating a number in VB

How do I truncate numbers in VB Excel(2000)?


I am in Excel's VB and having problems getting the VB to
see the two figures below as the same amount. I have tried
it as a single and double, but it doesn't work.

number1= 1.06000201020
number2= 1.06000606060

I'd like excel to see it as
number1=number2
not
number1<number2