PDA

View Full Version : Apply Number Format to all New & existing spreadsheets


Dulcie2009
Mar 18, 2009, 06:15 PM
Hi,

I've been trying to change the negative number formats or generally apply a similar format to all existing & New spreadsheets inregards to numbers. Tried changing the Regional settings but still no result. Any help on how to apply the format to all the cells/spreadsheet at once would be greatly appreciated.

Thanks in advance,

Dulcie

ROLCAM
Mar 18, 2009, 06:45 PM
Dulcie,

There is a small square just above the 1
And left to the A.
Press that down and see how you go.

ScottGem
Mar 18, 2009, 07:04 PM
What spreadsheet are you aksing about? What version?

Dulcie2009
Mar 18, 2009, 08:57 PM
ScottGem, I'm using Microsoft office 2003.

Just tried what ROLCAM suggested but this seem to apply to the current workbook
Only. Is there a Reginonal setting or anything I can do, so the format applies to all
The existing spreadsheet on my PC?

Thanks

JBeaucaire
Mar 18, 2009, 09:16 PM
Follow the steps outlined on this page to alter the behavior of the Book.xlt located in the XLSTART folder:

Control the Defaults for Excel Number Formats (http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=65)

ScottGem
Mar 19, 2009, 06:00 AM
When you open an Excel workbook, it reads the default formats and styles from a template file. That's why I needed to know what spreadsheet you were using. You need to save your formatting in that file which is book.xlt as the article JB linked to points out.

JBeaucaire
Mar 19, 2009, 12:47 PM
Ever wonder why new workbooks were called Book1, Book2, Book3? Ever start a new sheet from a template you created? Notice how that uses your template name and adds a 1, 2, 3, etc?

It's the same thing. Whatever new workbooks are called when you click CTRL-N, that's the name of the workbook to find in the XLStart folder.

Dulcie2009
Mar 22, 2009, 08:31 PM
Ever wonder why new workbooks were called Book1, Book2, Book3? Ever start a new sheet from a template you created? Notice how that uses your template name and adds a 1, 2, 3, etc?

It's the same thing. Whatever new workbooks are called when you click CTRL-N, that's the name of the workbook to find in the XLStart folder.

Thanks JB!!

I selected all the spreadsheet like what ScottGem had suggested & after then following the link I manage to get it done.

Thanks to you & ScottGem!