View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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