Hi
The following code will show result in percentage with left aligned(TEXT) in
excel. My requirement is that the result should be right aligned (in number
format)
with the same percentage symbol along with the result. ( rather than
text with left aligned). Otherwise the code works fine and no change is
required.

Public Function CAGR(FirstValue, LastValue)
Dim fv, lv, v As Double
Set r = Application.Range(FirstValue, LastValue)
Count = (Application.Range(FirstValue, LastValue).Count - 1)
CAGR = FirstValue
v = Application.WorksheetFunction.Rate(Count, 0, -(FirstValue), LastValue)
CAGR = Format(v, "00.00%")
End Function

I am repeatedly asking for help but no avail. Will any one familiar with
this area would kindly help me. As I am not familar with the VBA and got this
thro one of my friend I am helpless.