In my XLSTART folder, I have saved an .xltm file, where a single line in the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get 2 decimals
for the cell(s). How can I make my "Comma" button ALWAYS display in the
"#,##0" format?
--
TIA, Brad E.

In a new workbook amend the Comma style as you want. Save the workbook with
no code in the XLSTART folder as a normal workbook named Book1.xlsx (or in
whatever format you prefer), note do not save as a template, no code
required.

This should act as the template for new workbooks.

Regards,
Peter T


"Brad E." wrote in message
...
In my XLSTART folder, I have saved an .xltm file, where a single line in
the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get 2
decimals
for the cell(s). How can I make my "Comma" button ALWAYS display in the
"#,##0" format?
--
TIA, Brad E.

Sorry that's not right at all, my memory must be playing tricks, will have a
look later

Peter T

"Peter T" <peter_t@discussions wrote in message
...
In a new workbook amend the Comma style as you want. Save the workbook
with no code in the XLSTART folder as a normal workbook named Book1.xlsx
(or in whatever format you prefer), note do not save as a template, no
code required.

This should act as the template for new workbooks.

Regards,
Peter T


"Brad E." wrote in message
...
In my XLSTART folder, I have saved an .xltm file, where a single line in
the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get 2
decimals
for the cell(s). How can I make my "Comma" button ALWAYS display in the
"#,##0" format?
--
TIA, Brad E.

I was nearly right, name it Book.xlsx

Regards,
Peter T

"Peter T" <peter_t@discussions wrote in message
...
In a new workbook amend the Comma style as you want. Save the workbook
with no code in the XLSTART folder as a normal workbook named Book1.xlsx
(or in whatever format you prefer), note do not save as a template, no
code required.

This should act as the template for new workbooks.

Regards,
Peter T


"Brad E." wrote in message
...
In my XLSTART folder, I have saved an .xltm file, where a single line in
the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get 2
decimals
for the cell(s). How can I make my "Comma" button ALWAYS display in the
"#,##0" format?
--
TIA, Brad E.

Still wrong, lets try again, save as a template named Book.xltx in the
XLSTART folder

Regards,
Peter T

"Peter T" <peter_t@discussions wrote in message
...
I was nearly right, name it Book.xlsx

Regards,
Peter T

"Peter T" <peter_t@discussions wrote in message
...
In a new workbook amend the Comma style as you want. Save the workbook
with no code in the XLSTART folder as a normal workbook named Book1.xlsx
(or in whatever format you prefer), note do not save as a template, no
code required.

This should act as the template for new workbooks.

Regards,
Peter T


"Brad E." wrote in message
...
In my XLSTART folder, I have saved an .xltm file, where a single line in
the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get 2
decimals
for the cell(s). How can I make my "Comma" button ALWAYS display in the
"#,##0" format?
--
TIA, Brad E.

Thanks, Peter, it works great for all new workbooks.

Now, do you know if there is a way to make that button act the same for all
workbooks? When I open an old workbook, and select a (pre-filled) cell to
change to My comma style, it still uses the MS Comma Style (with 2 decimals).
--
TIA, Brad E.


"Peter T" wrote:

In a new workbook amend the Comma style as you want. Save the workbook with
no code in the XLSTART folder as a normal workbook named Book1.xlsx (or in
whatever format you prefer), note do not save as a template, no code
required.

This should act as the template for new workbooks.

Regards,
Peter T


"Brad E." wrote in message
...
In my XLSTART folder, I have saved an .xltm file, where a single line in
the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get 2
decimals
for the cell(s). How can I make my "Comma" button ALWAYS display in the
"#,##0" format?
--
TIA, Brad E.

Our posts crossed, I suspect my suggestion as quoted below merely opens the
wb a single time, see my other post and save as a template named Book.xltx
in the start folder (note, without the "1" in the name)

Sorry for the confusion,
Peter T
..
"Brad E." wrote in message
...
Thanks, Peter, it works great for all new workbooks.

Now, do you know if there is a way to make that button act the same for
all
workbooks? When I open an old workbook, and select a (pre-filled) cell to
change to My comma style, it still uses the MS Comma Style (with 2
decimals).
--
TIA, Brad E.


"Peter T" wrote:

In a new workbook amend the Comma style as you want. Save the workbook
with
no code in the XLSTART folder as a normal workbook named Book1.xlsx (or
in
whatever format you prefer), note do not save as a template, no code
required.

This should act as the template for new workbooks.

Regards,
Peter T


"Brad E." wrote in message
...
In my XLSTART folder, I have saved an .xltm file, where a single line
in
the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get 2
decimals
for the cell(s). How can I make my "Comma" button ALWAYS display in
the
"#,##0" format?
--
TIA, Brad E.

Still not there...
I have changed the "Comma Style" button by going he
Home Styles Cell Styles Comma (right-click) Modify

I have saved this Workbook as an .xlsx and as an .xltx in the XLSTART
folder, deleting any other files which were in the folder. I don't see any
difference whether using xlsx or xltx. However, in each case, when I open a
pre-existing workbook, the button works as Microsoft's default setup.
--
TIA, Brad E.


"Peter T" wrote:

Our posts crossed, I suspect my suggestion as quoted below merely opens the
wb a single time, see my other post and save as a template named Book.xltx
in the start folder (note, without the "1" in the name)

Sorry for the confusion,
Peter T
..
"Brad E." wrote in message
...
Thanks, Peter, it works great for all new workbooks.

Now, do you know if there is a way to make that button act the same for
all
workbooks? When I open an old workbook, and select a (pre-filled) cell to
change to My comma style, it still uses the MS Comma Style (with 2
decimals).
--
TIA, Brad E.


"Peter T" wrote:

In a new workbook amend the Comma style as you want. Save the workbook
with
no code in the XLSTART folder as a normal workbook named Book1.xlsx (or
in
whatever format you prefer), note do not save as a template, no code
required.

This should act as the template for new workbooks.

Regards,
Peter T


"Brad E." wrote in message
...
In my XLSTART folder, I have saved an .xltm file, where a single line
in
the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get 2
decimals
for the cell(s). How can I make my "Comma" button ALWAYS display in
the
"#,##0" format?
--
TIA, Brad E.

Did you save as Book.xltx

For testing, colour format some cell in the saved Bookxltx, each time you
open a new book you should see your coloured cell. Note this only works for
new workbooks.

If you want all your old workbooks to include the modified style you'll need
to add it to each workbook as a one-off operation. Of course that can be
done programmatically, eg as a batch process open all files in a folder,
amend the built in style, save and close.

Regards,
Peter T

"Brad E." wrote in message
...
Still not there...
I have changed the "Comma Style" button by going he
Home Styles Cell Styles Comma (right-click) Modify

I have saved this Workbook as an .xlsx and as an .xltx in the XLSTART
folder, deleting any other files which were in the folder. I don't see
any
difference whether using xlsx or xltx. However, in each case, when I open
a
pre-existing workbook, the button works as Microsoft's default setup.
--
TIA, Brad E.


"Peter T" wrote:

Our posts crossed, I suspect my suggestion as quoted below merely opens
the
wb a single time, see my other post and save as a template named
Book.xltx
in the start folder (note, without the "1" in the name)

Sorry for the confusion,
Peter T
..
"Brad E." wrote in message
...
Thanks, Peter, it works great for all new workbooks.

Now, do you know if there is a way to make that button act the same for
all
workbooks? When I open an old workbook, and select a (pre-filled) cell
to
change to My comma style, it still uses the MS Comma Style (with 2
decimals).
--
TIA, Brad E.


"Peter T" wrote:

In a new workbook amend the Comma style as you want. Save the workbook
with
no code in the XLSTART folder as a normal workbook named Book1.xlsx
(or
in
whatever format you prefer), note do not save as a template, no code
required.

This should act as the template for new workbooks.

Regards,
Peter T


"Brad E." wrote in message
...
In my XLSTART folder, I have saved an .xltm file, where a single
line
in
the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get 2
decimals
for the cell(s). How can I make my "Comma" button ALWAYS display in
the
"#,##0" format?
--
TIA, Brad E.

I never did use BOOK1, always just BOOK, so I wasn't having some problems you
were. The testing I used was to close Excel and open Excel. When typing a
number 999 in A1, it would display as "1234". After clicking the "Comma
Style" button, it would display as "1,234". This morning, though, the button
would have made it display as "1,234.00 " (notice the trailing space, too...I
don't like that)

Thanks for the answer, that this is relative to the specific workbook and I
would have to programmatically change all existing workbooks.

I thought of a couple of questions while typing up this last comment.

Is this button format saved for the Workbook, and all co-workers (network
drive) will get the same functionality in any Workbook I create, or is it
specific to my machine and workbook?

How does Book.xltx differ from Book.xlsx? I have never been clear on when
to use a template file.

Thanks again, Peter
--
Brad E.


"Peter T" wrote:

Did you save as Book.xltx

For testing, colour format some cell in the saved Bookxltx, each time you
open a new book you should see your coloured cell. Note this only works for
new workbooks.

If you want all your old workbooks to include the modified style you'll need
to add it to each workbook as a one-off operation. Of course that can be
done programmatically, eg as a batch process open all files in a folder,
amend the built in style, save and close.

Regards,
Peter T

"Brad E." wrote in message
...
Still not there...
I have changed the "Comma Style" button by going he
Home Styles Cell Styles Comma (right-click) Modify

I have saved this Workbook as an .xlsx and as an .xltx in the XLSTART
folder, deleting any other files which were in the folder. I don't see
any
difference whether using xlsx or xltx. However, in each case, when I open
a
pre-existing workbook, the button works as Microsoft's default setup.
--
TIA, Brad E.


"Peter T" wrote:

Our posts crossed, I suspect my suggestion as quoted below merely opens
the
wb a single time, see my other post and save as a template named
Book.xltx
in the start folder (note, without the "1" in the name)

Sorry for the confusion,
Peter T
..
"Brad E." wrote in message
...
Thanks, Peter, it works great for all new workbooks.

Now, do you know if there is a way to make that button act the same for
all
workbooks? When I open an old workbook, and select a (pre-filled) cell
to
change to My comma style, it still uses the MS Comma Style (with 2
decimals).
--
TIA, Brad E.


"Peter T" wrote:

In a new workbook amend the Comma style as you want. Save the workbook
with
no code in the XLSTART folder as a normal workbook named Book1.xlsx
(or
in
whatever format you prefer), note do not save as a template, no code
required.

This should act as the template for new workbooks.

Regards,
Peter T


"Brad E." wrote in message
...
In my XLSTART folder, I have saved an .xltm file, where a single
line
in
the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get 2
decimals
for the cell(s). How can I make my "Comma" button ALWAYS display in
the
"#,##0" format?
--
TIA, Brad E.

Is this button format saved for the Workbook,

Yes, that is, if by "button" you mean the amendable Comma style. So for your
new workbooks based on Book.xltx the styles will persist, as indeed will any
other workbooks that have been updated with "your" styles.

I'm relying here on memory here, which has already been shown to be fallible
as to exactly how to define a custom formatted default workbook! But easy
enough for you to test and check out for yourself.

Regards,
Peter T


"Brad E." wrote in message
...
I never did use BOOK1, always just BOOK, so I wasn't having some problems
you
were. The testing I used was to close Excel and open Excel. When typing
a
number 999 in A1, it would display as "1234". After clicking the "Comma
Style" button, it would display as "1,234". This morning, though, the
button
would have made it display as "1,234.00 " (notice the trailing space,
too...I
don't like that)

Thanks for the answer, that this is relative to the specific workbook and
I
would have to programmatically change all existing workbooks.

I thought of a couple of questions while typing up this last comment.

Is this button format saved for the Workbook, and all co-workers (network
drive) will get the same functionality in any Workbook I create, or is it
specific to my machine and workbook?

How does Book.xltx differ from Book.xlsx? I have never been clear on when
to use a template file.

Thanks again, Peter
--
Brad E.


"Peter T" wrote:

Did you save as Book.xltx

For testing, colour format some cell in the saved Bookxltx, each time you
open a new book you should see your coloured cell. Note this only works
for
new workbooks.

If you want all your old workbooks to include the modified style you'll
need
to add it to each workbook as a one-off operation. Of course that can be
done programmatically, eg as a batch process open all files in a folder,
amend the built in style, save and close.

Regards,
Peter T

"Brad E." wrote in message
...
Still not there...
I have changed the "Comma Style" button by going he
Home Styles Cell Styles Comma (right-click) Modify

I have saved this Workbook as an .xlsx and as an .xltx in the XLSTART
folder, deleting any other files which were in the folder. I don't see
any
difference whether using xlsx or xltx. However, in each case, when I
open
a
pre-existing workbook, the button works as Microsoft's default setup.
--
TIA, Brad E.


"Peter T" wrote:

Our posts crossed, I suspect my suggestion as quoted below merely
opens
the
wb a single time, see my other post and save as a template named
Book.xltx
in the start folder (note, without the "1" in the name)

Sorry for the confusion,
Peter T
..
"Brad E." wrote in message
...
Thanks, Peter, it works great for all new workbooks.

Now, do you know if there is a way to make that button act the same
for
all
workbooks? When I open an old workbook, and select a (pre-filled)
cell
to
change to My comma style, it still uses the MS Comma Style (with 2
decimals).
--
TIA, Brad E.


"Peter T" wrote:

In a new workbook amend the Comma style as you want. Save the
workbook
with
no code in the XLSTART folder as a normal workbook named Book1.xlsx
(or
in
whatever format you prefer), note do not save as a template, no
code
required.

This should act as the template for new workbooks.

Regards,
Peter T


"Brad E." wrote in message
...
In my XLSTART folder, I have saved an .xltm file, where a single
line
in
the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get
2
decimals
for the cell(s). How can I make my "Comma" button ALWAYS display
in
the
"#,##0" format?
--
TIA, Brad E.

Pre-existing workbooks will not be affected by your settings in xltx
template.

Only new workbooks.

Styles are saved with the workbook so you will have to change the style in
the pre-existing workbooks.


Gord Dibben MS Excel MVP

On Thu, 5 Mar 2009 09:46:01 -0800, Brad E.
wrote:

Still not there...
I have changed the "Comma Style" button by going he
Home Styles Cell Styles Comma (right-click) Modify

I have saved this Workbook as an .xlsx and as an .xltx in the XLSTART
folder, deleting any other files which were in the folder. I don't see any
difference whether using xlsx or xltx. However, in each case, when I open a
pre-existing workbook, the button works as Microsoft's default setup.

When using a Template, a workbook is opened based on that Template.

The Template is never opened directly, so users cannot edit it, just edit
the opened workbook and save as whatever name suits them.

Template remains untouched ready for next use..

*.xlsx is just a regular workbook. If users edit and save, you have lost
the original.


Gord Dibben MS Excel MVP


On Thu, 5 Mar 2009 10:28:02 -0800, Brad E.
wrote:

How does Book.xltx differ from Book.xlsx? I have never been clear on when
to use a template file.