|
|
|
|
New Member
|
|
Mar 18, 2009, 06:15 PM
|
|
Apply Number Format to all New & existing spreadsheets
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
|
|
|
Ultra Member
|
|
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.
|
|
|
Computer Expert and Renaissance Man
|
|
Mar 18, 2009, 07:04 PM
|
|
What spreadsheet are you aksing about? What version?
|
|
|
New Member
|
|
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
|
|
|
Computer Expert and Renaissance Man
|
|
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.
|
|
|
Software Expert
|
|
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.
|
|
|
New Member
|
|
Mar 22, 2009, 08:31 PM
|
|
Originally Posted by JBeaucaire
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!
|
|
Question Tools |
Search this Question |
|
|
Add your answer here.
Check out some similar questions!
Phone number format
[ 2 Answers ]
I need to change the format of phone numbers in excel from the standard 000-000-0000 to #10000000000.
Linking Excel Spreadsheets
[ 1 Answers ]
:confused:
Hi There
ANyone know how I can link excel spreadsheets to each other?:confused:
View more questions
Search
|