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 » Round up function
Round up function
Resolved · Low Priority · Version 2003
Fri 17 Apr 2009, 13:55Delegate Shane said...
Shane has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Round up function
On the round function how do you get 7MIL i/o 7,000,000
Sat 18 Apr 2009, 06:10Trainer Rajeev said...
RE: Round up function
Dear Shane
Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.
Please select all the values that have Million figures in it.
Format > Cells... from the Menu Bar
Choose Custom from the Number tab
In the They box enter the following:
#,##0,, "Mil" ;[Red](#,##0,,);- ;
Note: you can simply copy and paste the above custom format. (CTRL +C (Copy) and CTRL +V (Paste)
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
Fri 24 Apr 2009: Automatically marked as resolved.
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:Autofit column width – Excel (all versions)a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column. |
