ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel rounding bug for input to Variant data type (https://www.excelbanter.com/excel-programming/350816-excel-rounding-bug-input-variant-data-type.html)

Greg[_24_]

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?



All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com