Using Excel COM Interface to receive an excel cell "G20" with value of 0.932835820895522. But the result I got is 0.9328356.
The Excel COM command using to retreive is "xl.Range("G20").Text"
Need help with Excel COM Interface precision
Moderator: Pulover
-
- Posts: 74
- Joined: 12 Nov 2022, 15:47
Re: Need help with Excel COM Interface precision
Use the command "xl.Range("G20").Value" instead of text. Even if the cell contents is a formula "Value" will grab the number value.
Actually, I think you need to use the format function to display 15 decimals. String := Format(FormatStr , Values...)
Return to “Pulovers Macro Creator”
Who is online
Users browsing this forum: No registered users and 33 guests