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
