Currency formating

S

Sallie

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!
 
D

Dave Peterson

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.
 
D

Dave Peterson

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.
 
S

Sallie

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 said:
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.
 
D

Dave Peterson

Glad you got it working.

This is a pretty informal group. First names are ok (well, for me anyway).
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 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top