i have vba script generates allocations need precise out 20 decimal places. use cdec() fill array proper decimal precision. issue have when output array excel worksheet, decimal precision drops significantly. instance, confirmed in array, number 0.1557094848581301243552712433, when output worksheet, drops 0.15570948485813. can write array text file , further confirm array holds correct level of precision. have tried creating pipe delimited text file , doing texttocolumns no avail.
does know how maintain higher level of decimal precision when bringing numbers excel?
simply put: excel supports 15 digit precision "when displaying". msft kb reference below. oddly stores correct value, can't (or doesn't) represent it.
work arounds
- certain addins may (see references)
- store value text. has no such limit no math or rounding may occur
references:
Comments
Post a Comment