SQLFunction is formatting results? Quote:SQLFunction(...) seems to be formatting the result. This should be probably handled by Excel, e.g., in the case there's a customized decimal separator in Excel.
Answer: I agree that this should be handled by Excel however to prevent problems SQL*XL does catch some problematic cases.
It all depends on the datatype of the returned value. This is passed to SQL*XL as a variant. If the data type is a vbDecimal value it will do a CDbl to try to convert the value. In very few cases there are problems with database servers sending the information as texts instead of as binary numbers. Then number formats become important.
Also null or empty values will be set to vbNullString.
On errors an error string will be put in the result value.