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

ROLCAM

Dulcie,

There is a small square just above the 1
and left to the A.
Press that down and see how you go.

ScottGem

What spreadsheet are you aksing about? What version?

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

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

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.

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.

Dulcie2009

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!