Posted to microsoft.public.excel.programming

Eric[_24_] Eric[_24_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Truncating a VIN	lputnam	Excel Discussion (Misc queries)	3	November 11th 09 05:28 PM
text truncating	Overcome by info	Excel Discussion (Misc queries)	2	October 1st 07 04:16 PM
truncating series	Michael	Charts and Charting in Excel	0	May 31st 06 11:41 AM
Truncating numbers	Susana C via OfficeKB.com	Excel Worksheet Functions	1	May 8th 06 04:42 PM
truncating and rounding	Chang	Excel Programming	1	November 20th 03 05:00 PM

All times are GMT +1. The time now is 11:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us