View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg[_24_] Greg[_24_] is offline
external usenet poster
 
Posts: 1
Default 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?