ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Currency Style button (https://www.excelbanter.com/excel-discussion-misc-queries/22297-currency-style-button.html)

Anita

Currency Style button
 
When I click the Currency Style button on the Formatting toolbar my data is
formatted as Accounting. Wouldn't it logically be formatted as Currency? I'm
assuming that the Currency Style button actually refers to the type of
currency (English dollar, British pound, etc.) rather than the type of
formatting applied. However, doesn't the use of "Currency Style" on the
button name imply that it will apply the Currency style formatting? Any
thoughts on this?
--
Anita

RagDyeR

It is what Redmond decides it is!?!?<g

However, you can change it to suit your own preferences.

<Format <Style
And expand the "Style Name" window,
And then click on "Currency".

Click on "Modify", which brings up the standard, familiar Format window.

Adjust the format to what you wish, then <OK <OK.
--

HTH,


RD
==============================*================
Please keep all correspondence within the Group, so all may benefit!
==============================*================


"Anita" wrote in message
...
When I click the Currency Style button on the Formatting toolbar my data is
formatted as Accounting. Wouldn't it logically be formatted as Currency? I'm
assuming that the Currency Style button actually refers to the type of
currency (English dollar, British pound, etc.) rather than the type of
formatting applied. However, doesn't the use of "Currency Style" on the
button name imply that it will apply the Currency style formatting? Any
thoughts on this?
--
Anita



Anita

RD,

Thank you so much for your quick response...your information was very helpful.

Anita

"RagDyeR" wrote:

It is what Redmond decides it is!?!?<g

However, you can change it to suit your own preferences.

<Format <Style
And expand the "Style Name" window,
And then click on "Currency".

Click on "Modify", which brings up the standard, familiar Format window.

Adjust the format to what you wish, then <OK <OK.
--

HTH,


RD
==============================Â*================
Please keep all correspondence within the Group, so all may benefit!
==============================Â*================


"Anita" wrote in message
...
When I click the Currency Style button on the Formatting toolbar my data is
formatted as Accounting. Wouldn't it logically be formatted as Currency? I'm
assuming that the Currency Style button actually refers to the type of
currency (English dollar, British pound, etc.) rather than the type of
formatting applied. However, doesn't the use of "Currency Style" on the
button name imply that it will apply the Currency style formatting? Any
thoughts on this?
--
Anita




Ragdyer

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Anita" wrote in message
...
RD,

Thank you so much for your quick response...your information was very

helpful.

Anita

"RagDyeR" wrote:

It is what Redmond decides it is!?!?<g

However, you can change it to suit your own preferences.

<Format <Style
And expand the "Style Name" window,
And then click on "Currency".

Click on "Modify", which brings up the standard, familiar Format window.

Adjust the format to what you wish, then <OK <OK.
--

HTH,


RD
==============================Â*================
Please keep all correspondence within the Group, so all may benefit!
==============================Â*================


"Anita" wrote in message
...
When I click the Currency Style button on the Formatting toolbar my data

is
formatted as Accounting. Wouldn't it logically be formatted as Currency?

I'm
assuming that the Currency Style button actually refers to the type of
currency (English dollar, British pound, etc.) rather than the type of
formatting applied. However, doesn't the use of "Currency Style" on the
button name imply that it will apply the Currency style formatting? Any
thoughts on this?
--
Anita






All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com