setNumberFormat in custom excel function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

puni - 10 Dec 2007 20:47 GMT

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.

Reply to this Message

Jim Thomlinson - 10 Dec 2007 21:21 GMT

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.

Signature

HTH...

Jim Thomlinson

> 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
[quoted text clipped - 5 lines]
>
> Is there any workaround for this.

Reply to this Message