Posted to microsoft.public.excel.programming

Greg[_24_] Greg[_24_] is offline

external usenet poster

Posts: 1

Excel rounding bug for input to Variant data type

Excel has a bug when reading a text file for input to a Variant data
type: the values are rounded to two decimal places regardless of the
number of decimal places of the value in the text file.

For example, if PAR is a Variant data type and unit #1 is a text file
that has a value of 0.5176, the following input statement will read the
value of PAR as 0.52:

Input #1, PAR

Is there any way to read input values to a Variant data type without
this rounding?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
how to redim the type of variant element	lvcha.gouqizi	Excel Programming	5	October 25th 05 07:05 PM
VBA problem pulling data out of variant/range input variables	[email protected]	Excel Programming	2	April 6th 05 04:56 PM
Type mismatch accessing variant array too many times	peter	Excel Programming	6	February 12th 05 10:07 PM
Variant type for Excel cell percentage data format	Mike	Excel Programming	4	October 21st 04 01:03 AM
How to check a Variant for its data type	TBA[_2_]	Excel Programming	5	January 9th 04 11:04 PM

All times are GMT +1. The time now is 06:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us