Hi , i create UDF mypc which gives percent of the passed number as i need to
change the number format of given cell on some calculation,


function mypc(rng as long)
mypc=format(rng,"percent")
end function

Suppose In worksheet , A1 contains value 5

In B2, i type = mypc(A1) - RETURNS 500%, but i am not able to perform
calculation on this returned values.

please help
Thanx