Currency formating
 

Hello,

I have a document that has been sent to me, the numbers show as 2 000,00 $
which is correct, but when I click on the currency button on my tool bar it
than changes to 2 000,00 F. If I use the currency button in a new or in a
nother document everything is OK.

Can you please help me with that document

Thank you in advance for your precious help!
--
Sallie

Currency formating
 

When you click on the Currency icon on the toolbar, you're applying the Currency
Style.

And this style (like all styles) live in workbooks.

So if you want to change this style, you can:
Activate the workbook with the troublesome style
Format|Style|Select Currency
Click Modify and change what you want.



Sallie wrote:

Hello,

I have a document that has been sent to me, the numbers show as 2 000,00 $
which is correct, but when I click on the currency button on my tool bar it
than changes to 2 000,00 F. If I use the currency button in a new or in a
nother document everything is OK.

Can you please help me with that document

Thank you in advance for your precious help!
--
Sallie

--

Dave Peterson

Currency formating
 

ps. Just to expand a bit.

Each workbook has its own styles. Changing a style in one workbook won't change
the same style in other workbooks.

Dave Peterson wrote:

When you click on the Currency icon on the toolbar, you're applying the Currency
Style.

And this style (like all styles) live in workbooks.

So if you want to change this style, you can:
Activate the workbook with the troublesome style
Format|Style|Select Currency
Click Modify and change what you want.

Sallie wrote:

Hello,

I have a document that has been sent to me, the numbers show as 2 000,00 $
which is correct, but when I click on the currency button on my tool bar it
than changes to 2 000,00 F. If I use the currency button in a new or in a
nother document everything is OK.

Can you please help me with that document

Thank you in advance for your precious help!
--
Sallie

--

Dave Peterson

--

Dave Peterson

Currency formating
 

Dear Mr Peterson,

Thank you so much I modified the currency style, just like you proposed and
it worked perfectly. Thank you very much it is very appreciated
--
Sallie


"Dave Peterson" wrote:

ps. Just to expand a bit.

Each workbook has its own styles. Changing a style in one workbook won't change
the same style in other workbooks.

Dave Peterson wrote:

When you click on the Currency icon on the toolbar, you're applying the Currency
Style.

And this style (like all styles) live in workbooks.

So if you want to change this style, you can:
Activate the workbook with the troublesome style
Format|Style|Select Currency
Click Modify and change what you want.

Sallie wrote:

Hello,

I have a document that has been sent to me, the numbers show as 2 000,00 $
which is correct, but when I click on the currency button on my tool bar it
than changes to 2 000,00 F. If I use the currency button in a new or in a
nother document everything is OK.

Can you please help me with that document

Thank you in advance for your precious help!
--
Sallie

--

Dave Peterson

--

Dave Peterson

Currency formating
 

Glad you got it working.

This is a pretty informal group. First names are ok (well, for me anyway).

Sallie wrote:

Dear Mr Peterson,

Thank you so much I modified the currency style, just like you proposed and
it worked perfectly. Thank you very much it is very appreciated
--
Sallie

"Dave Peterson" wrote:

ps. Just to expand a bit.

Each workbook has its own styles. Changing a style in one workbook won't change
the same style in other workbooks.

Dave Peterson wrote:

When you click on the Currency icon on the toolbar, you're applying the Currency
Style.

And this style (like all styles) live in workbooks.

So if you want to change this style, you can:
Activate the workbook with the troublesome style
Format|Style|Select Currency
Click Modify and change what you want.

Sallie wrote:

Hello,

I have a document that has been sent to me, the numbers show as 2 000,00 $
which is correct, but when I click on the currency button on my tool bar it
than changes to 2 000,00 F. If I use the currency button in a new or in a
nother document everything is OK.

Can you please help me with that document

Thank you in advance for your precious help!
--
Sallie

--

Dave Peterson

--

Dave Peterson


--

Dave Peterson