Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
Conditional Formating - Currency | Excel Discussion (Misc queries) | |||
script for date and currency formating | Excel Discussion (Misc queries) | |||
Currency formating problem | Excel Discussion (Misc queries) | |||
Currency formating problem | Excel Discussion (Misc queries) |