Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formating cells with 2 decimal places within a template

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Formating cells with 2 decimal places within a template

Resolved · Medium Priority · Version 2007

Reply 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?

For upcoming training course dates see: Pricing & availability

Reply 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.

Excel articles

· Interesting Things About Charts In Excel 2003
· A Brief Glimpse At Excel's What If Analyses Tools
· Using Headers And Footers In Excel 2010
· An Introduction To Financial Functions In Excel 2010
· Creating A Clearer Picture With Excel

Please browse our web site to find out more about
application development excel and other Microsoft training courses.

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips