![]() |
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