| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a VBA Function return a value in percent format
Hi,
I've been searching google for a while on this question but I can't find anything. I wrote a very simple function that returns the growth percentage between two numbers: Function GP(Val1 As Double, Val2 As Double) GP = (Val2 - Val1) / Val1 End Function I would like the result to automatically be displayed in "%0.00" format but I cannot figure out how to make that happen. Right now it returns a number like 0.45632 and I have to click the cell and format it to percentage. Is this possible? Thanks. John Black |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Howw can I make a function return a date in date format | Excel Programming | |||
| Make VBA wait for return from external function | Excel Programming | |||
| How do I make the true return a drop down list in the IF function? | Excel Worksheet Functions | |||
| trying to make a formula for percent if greater than a value | Excel Discussion (Misc queries) | |||
| Percent Format without Percent Sign | Excel Programming | |||
Threaded Mode
