Hi,
I'm trying to get data from an excel file with 10 decimal places but the string length seems to only pick up the first 9. Is there a maximum set to 9? Can this be changed?
Thanks,
Andrew
Decimal places
- flyingDman
- Posts: 2821
- Joined: 29 Sep 2013, 19:01
Re: Decimal places
try:
see: https://docs.microsoft.com/en-us/office/vba/api/excel.range.numberformat
Code: Select all
xl := ComObjActive("excel.application")
xl.selection.cells.NumberFormat := "0.00000000000000000000" ; change the # of 0's to your liking
; xl.activesheet.cells.NumberFormat := "0.00000000000000000000" ; for the whole worksheet
14.3 & 1.3.7