setNumberFormat in custom excel function

P

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.
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help file for VBA custom function 2
Display custom function 1
Access query(with custom function) from Excel 3
Autocomplete Custom Functions and functions arguments 1
How do I write a help file for a custom function? 1
Custom Function Add-In not working 4
function with collection of custom objects as results 0
Custom Function displays as #NAME 12

Top