View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
puni puni is offline
external usenet poster
 
Posts: 1
Default setNumberFormat in custom excel function

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,xFor matNumber)
inside the custom function.
The same call work's fine in all other places except custom excel
functions.

Is there any workaround for this.