<div>
OK, I can live with that unless someone else knows a better /different way<br />
<br />
Any idea how to print the sheet with invalid data circled ?
</div>


<div>
<div class="content wysiwyg-content">
Can anyone help with a couple of simple Excel 2007 quieries<br />
<br />
1. How can I print a sheet with the invalid data circled (I can use the circle invalid data option to show on screen but I want to be able to print this)<br />
<br />
2. How can I convert a time into a 'decimal time' ie I want to show minutes as a % of the hour - so if I enter 9:15 I get 9:25 &nbsp;(as 15 mins is 25% of an hour)<br />
<br />
Thanks
</div>
</div>


Can anyone help with a couple of simple Excel 2007 quieries

1. How can I print a sheet with the invalid data circled (I can use the circle invalid data option to show on screen but I want to be able to print this)

2. How can I convert a time into a 'decimal time' ie I want to show minutes as a % of the hour - so if I enter 9:15 I get 9:25  (as 15 mins is 25% of an hour)

Thanks

OK, I can live with that unless someone else knows a better /different way

Any idea how to print the sheet with invalid data circled ?

Couple of simple (I hope) Excel 2007 queries

Can anyone help with a couple of simple Excel 2007 quieries

1. How can I print a sheet with the invalid data circled (I can use the circle invalid data option to show on screen but I want to be able to print this)

2. How can I convert a time into a &amp;#39;decimal time&amp;#39; ie I want to show minutes as a % of the hour - so if I enter 9:15 I get 9:25  (as 15 mins is 25% of an hour)

Thanks

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.