setNumberFormat in custom excel function

[puni]

I have a custom C++ excel function. When the function's output is a
number, I want to format it with commas in 1000s and right justify in
the cell. I get return code 2 when I try using
success = XlfExcel::Instance().Call(xlcFormatNumber,0,1,xFormatNumber)
inside the custom function.
The same call work's fine in all other places except custom excel
functions.

Is there any workaround for this.

 

[Jim Thomlinson]

UDF's return values and that is it. They can not modify formats nor can they
change the values of cells that they are not in... When called from within
code they have free reign to do what they want, but not when called as a
function from a cell.