Ask Experts Questions for FREE Help !
Ask

Apply Number Format to all New & existing spreadsheets

Asked Mar 18, 2009, 06:15 PM — 7 Answers
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

Search this Thread
Share |
7 Answers
ROLCAM's Avatar
ROLCAM Posts: 1,437, Reputation: 250
Ultra Member
  
#2

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:00 PM): That square simply selects the entire spreadsheet in Excel   Source:
Helpful
ScottGem's Avatar
ScottGem Posts: 58,093, Reputation: 28135
Computer Expert and Renaissance Man
  
#3

Mar 18, 2009, 07:04 PM


What spreadsheet are you aksing about? What version?
Helpful
Dulcie2009's Avatar
Dulcie2009 Posts: 11, Reputation: 1
New Member
  
#4

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
Helpful
JBeaucaire's Avatar
JBeaucaire Posts: 5,377, Reputation: 5036
Software Expert
  
#5

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
Helpful  (1)
ScottGem's Avatar
ScottGem Posts: 58,093, Reputation: 28135
Computer Expert and Renaissance Man
  
#6

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.
Helpful
JBeaucaire's Avatar
JBeaucaire Posts: 5,377, Reputation: 5036
Software Expert
  
#7

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.
Helpful
Dulcie2009's Avatar
Dulcie2009 Posts: 11, Reputation: 1
New Member
  
#8

Mar 22, 2009, 08:31 PM
Quote:
Originally Posted by JBeaucaire View Post
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!
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



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 Spreadsheets questions Search