98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training in london - Visal basic Myfunction formula
microsoft excel training in london - Visal basic Myfunction formula
Resolved · Low Priority · Version Standard
Fri 18 Jan 2008, 16:27Delegate Gary said...
Gary has attended:
Excel Intermediate course
Excel Advanced course
Visal basic Myfunction formula
When using visal basic Myfunction formulas during my course on the 18/01/2008 with Pete Emmerson I asked the following question.
When pulling a % through to excel there were decimal places I would like to round. e.g so that in the excel spreadsheet it displays 40% not 40.52. Please could you tell me how to display this number as 40%.
Sat 19 Jan 2008, 21:20Trainer Rajeev said...
RE: Visal basic Myfunction formula
Dear Gary
Thank you for attending Excel Advanced Course.
I have uploaded an Excel File MyFunction that I created for your reference.
Step 1: I created the [b]
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Calculate age or serviceThe DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip: |
