Setting NumberFormat of value returned from UDF

[drocco]

I am using a UDF to calculate the % change between two numbers
I want the value that's returned to be automatically formatted as a percentage
Here is my code so far

Public Function PercentChange(current, last)

    PercentChange = (current - last) / Abs(last)
    
End Function

What do I need to add to accomplish this

 

[Jonmo1]

A UDF Called from a Cell Formula can't change the format of a cell.

Sorry, you'll have to format the cell by hand (if you want the result to remain a number).

You could force it to show as text with the %, but the value will not be an actual number

PercentChange = Format((current - last) / Abs(last), "0%")

 

[drocco]

Having the value returned as text will probably do just fine my case
Thanks for your help!