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 » Formating cells with 2 decimal places within a template
Formating cells with 2 decimal places within a template
Resolved · Medium Priority · Version 2007
Thu 19 Feb 2009, 23:25Delegate Chris said...
Chris has attended:
Excel Intermediate course
Formating cells with 2 decimal places within a template
I have created a template where by I have a 50 rows and 5 columns. All columns and rows contain numbers which are formated as 2 decimal places. When I open the template and only enter 25 rows of data the remaining 25 rows show '0' in the cells. How do I make it so that cells with no data or sums show as an empty cell?
Fri 20 Feb 2009, 11:16Trainer Amanda said...
RE: formating cells with 2 decimal places within a template
Hello Chris
Thank you for your question and welcome to the forum.
There are numerous solutions to this, depending on how you want to go about achieving this.
There is a useful page on the Microsoft web site outlining the various techniques you can use to achieve this:
http://office.microsoft.com/en-us/excel/HP100704611033.aspx
Kind regards
Amanda
Fri 27 Feb 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:Deleting a range of cells using the autofill handleFirstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted. |
