Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Apply Number Format to all New & existing spreadsheets (https://www.askmehelpdesk.com/showthread.php?t=331034)

  • Mar 18, 2009, 06:15 PM
    Dulcie2009
    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
  • Mar 18, 2009, 06:45 PM
    ROLCAM

    Dulcie,

    There is a small square just above the 1
    And left to the A.
    Press that down and see how you go.
  • Mar 18, 2009, 07:04 PM
    ScottGem

    What spreadsheet are you aksing about? What version?
  • Mar 18, 2009, 08:57 PM
    Dulcie2009
    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
  • Mar 18, 2009, 09:16 PM
    JBeaucaire

    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
  • Mar 19, 2009, 06:00 AM
    ScottGem
    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.
  • Mar 19, 2009, 12:47 PM
    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.
  • Mar 22, 2009, 08:31 PM
    Dulcie2009
    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!

  • All times are GMT -7. The time now is 12:49 AM.