UDF's can not modify formats. A function called from within Code can act upon
any cells to change formats and whatever else that they want. When called
from a sheet however UDF's can ONLY return values to the cell that they are
in. They can not modify the values of cells that they are not in and they can
not modify the format of any cells. Just one of those rules...
--
HTH...

Jim Thomlinson


"Salman" wrote:

Hi,
I need a user defined function to return formatted output

function userdefined(arg1, arg2) as double
userdefined = arg1/arg2
end function

I want the output as a percentage. Pls let me know the statement for that.
Thanks.