Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Template format changes

How do I change the default formatting for "$", "%" and"," when I open a NEW
file? When I enter a large number and select comma formatting, it gives me
two decimals, and I want none. I would like one decimal with percent format.

Older versions of Excel allowed you to save a normal.xlt file with changes.
When I add a personal template, Excel won't load it without me selecting it
each time.

Tom
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default Template format changes

Excel never had a Normal.xlt, it had a BOOK.XLT

Open a new workbook. Customize as you wish.

FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew or
CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you will get the
Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP

On Tue, 18 Dec 2007 16:04:01 -0800, tkSkyland
wrote:

How do I change the default formatting for "$", "%" and"," when I open a NEW
file? When I enter a large number and select comma formatting, it gives me
two decimals, and I want none. I would like one decimal with percent format.

Older versions of Excel allowed you to save a normal.xlt file with changes.
When I add a personal template, Excel won't load it without me selecting it
each time.

Tom


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Template format changes



"tkSkyland" wrote:

How do I change the default formatting for "$", "%" and"," when I open a NEW
file? When I enter a large number and select comma formatting, it gives me
two decimals, and I want none. I would like one decimal with percent format.

Older versions of Excel allowed you to save a normal.xlt file with changes.
When I add a personal template, Excel won't load it without me selecting it
each time.

Tom


Thank you. It worked. I was saving the templates in the "template" folder,
which of course didn't work.

Tom
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format charts in Excel using a template Ralph Bentley Charts and Charting in Excel 1 October 30th 07 03:58 PM
How do I format default cells in a template gemcare Excel Worksheet Functions 0 April 11th 06 08:11 AM
Template: Format font size Diana Excel Discussion (Misc queries) 0 November 23rd 05 10:54 AM
My date format is not as the template states Denise Excel Worksheet Functions 2 August 10th 05 07:29 PM
How do I format template zoomed? Bizman Setting up and Configuration of Excel 0 March 14th 05 09:53 PM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"