<div>
Thanks. Actually I wanted a macro but this works fine.
</div>


Thanks. Actually I wanted a macro but this works fine.

<div>
<div class="content wysiwyg-content">
I have a workbook and would like to format all the worksheets apart from worksheet &quot;A&quot;.<br />
<br />
So, for all other worksheets, column B should be a percentage number with 2 decimal points, and columns C:K should be a number with no decimal points.<br />
<br />
Can you help please?<br />
Thanks,<br />
Chris
</div>
</div>


I have a workbook and would like to format all the worksheets apart from worksheet "A".

So, for all other worksheets, column B should be a percentage number with 2 decimal points, and columns C:K should be a number with no decimal points.

Can you help please?
Thanks,
Chris

excel format all sheets in a workbook

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 Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.