Decimal places

[JC1874]

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

[flyingDman]

try:

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

see: https://docs.microsoft.com/en-us/office/vba/api/excel.range.numberformat