Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Styles (Excel XP)

    How do I set a default style. I would like to have the Comma(,) icon to change my number style to () when an value is negative. Some way or other I managed to do it in Excel 2000 but can't seem to manage in XP.

    Thanks

    Mario

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Styles (Excel XP)

    Format, styles, select the Normal style, Modify, Number Tab, set the format you like, OK your way out.

    To get this on all new workbooks, format a workbook the way you want it and save it as Book.XLT, file type Template, in your XLSTART directory (below the directory from which Excel is loaded).

    Copy a worksheet from this workbook and save it as Sheet.XLT ,as above to get this for each newly inserted worksheet.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Styles (Excel XP)

    Thanks

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Styles (Excel XP)

    I followed these directions and now I have a problem with the normal style. I asked for normal to have two decimal places. Now when I type in the number 2005, I get 20.05. I have tried establishing a custom style but that is not correcting the problem. Any suggestions?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Styles (Excel XP)

    Check the Edit tab of Tools | Options...
    Make sure that the "Fixed decimal" check box is clear.

  6. #6
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Styles (Excel XP)

    That was it.

  7. #7
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Styles (Excel XP)

    Modifying the Book.XLT and Sheet.XLT has caused three problems. 1)When I turn on Excel I get both the Sheet.xlt and Book.Xlt to open instead of Book1. 2) When I go to save the first spreadsheet, it wants to save to the XLS Start directory so I always have to redirect to the correct drive, etc. 3) while working on a spreadsheet, if I want to insert a sheet, I get three sheets instead of 1. Any suggestions?

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Styles (Excel XP)

    1) Do a search for files named Book.xlt on your hard disk. Is there more than one? Same for Book.xlt. If there are multiple versions, where are they stored?
    2) Open Cocuments and Settings<username>Application DataMicrosoftExcelXLStartSheet.xlt. Delete all worksheets except the one with the desired formatting, then save it - after all, this template is the model used for inserting a new worksheet. If Sheet.xlt contains 3 worksheets, Insert | Worksheet will result in 3 sheets.

  9. #9
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Styles (Excel XP)

    Thank you. Yes, there was more than one Book.xlt. After I made this correction it still opens as Book.xlt, instead of Book1. Also, it still wants to save in XLStart directory instead of MyDocuments. How do I redirect.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Styles (Excel XP)

    I suspect that your Book.xlt is not a real Excel template, but a "normal" workbook saved with the .xlt extension.
    Move Book.xlt to another folder, then open it in Excel.
    Without changing anything, select File | Save As...
    Select Template (*.xlt) in the dropdown list at the bottom of the dialog.
    Navigate to your XLStart folder.
    Save as Book.xlt.
    Quit and restart Excel.

    If Excel still wants to save in XLStart:
    What is the setting for "Default file location" in the General tab of Tools | Options...?

  11. #11
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thank you

    Thank you. That worked.

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Thank you

    To fix the three sheet problem, repeat what Hans has advised,now naming it Sheet.xlt BUT make sure the workbook contains just a single worksheet
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Suggestions

    I took everyone suggestions and it worked perfectly on two machines. However, on one machine when Excel opens, there is no workbook open. I have to press the icon to open Book1. That is ok, I just wanted to know if there is something that can be done.

  14. #14
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Suggestions

    Could you check what startup switches are used in the Excel icon? (rightclick, properties, copy the text from the box called "Target" and paste here)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  15. #15
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Suggestions

    The text was grayed out but it is Microsoft Office Professional Edition 2003.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •