You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Before I dive into PivotTables, I thought I would mention an Excel 12 feature that resulted from collaboration with our international subsidiaries. Users that work outside North America (and even some users that work within North America) build a lot of spreadsheets that contain multiple currencies. To make this easier for folks, we’ve turned the “$” (or Currency Style) button into a split-button drop-down that contains a list of different currencies the user can select. The feature is pretty straightforward – if a user presses the button, it applies the default currency style in the same fashion as current versions of Excel. If the user presses the drop-down arrow on the button, they see a list of other common currencies that they can choose from.
(Click to enlarge)
In the same way the default currency style varies from country to country (for example, it is $ in the US, Pounds in the UK, Euros in most of Europe, Yen in Japan, etc.), the list of other currencies the users will see will vary from country to country (they will be specific to the user’s locale). We are working closely with our international subsidiaries to ensure that each locale has the most useful set of currency options for their users.
The “More…” option at the bottom of the drop down opens the Format Cells dialog to the Number tab.
Next week, PivotTables.
Comments: (8) Collapse
David,
Nice feature. Why not go one step further and add a currency conversion facility?
Colin
I like these alot...although I wish the selection became the button default (similar to the cell or font color picker).
Also, it would be very nice if the % and , also had the dropdown and the user could pick the 5 formatting options that are displayed.
-HT
What a simple yet super-useful feature! You guys have really outdone yourselves.
Hullo,
Thanks for the comments and suggestions.
How about including a format for Indian currency. I'm not too familiar with it. All I know is that there are an uneven number of spaces between commas and periods. I hacked a custom number format for somebody one time.
I have a page on number formats on my web site. I should add the description of the Indian currency format.
And in the UK, does the $ on the button display as a £ (as clicking it would give me the £ format, not the $ one)?
Hi Stephen,
Yes, the design as I understand it is that the default is set by locale (so in the UK it would be the pound symbol) and the rest of the choices would be currencies that are also used commonly in that locale (Euros, Swiss Francs, etc.). I will double check and let you know if there are any clarifications.
It would be nice if the Indian Number format came as a default instead of having to set it in the Custom format [>=10000000]##\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0 via a macro
Comments: (loading) Collapse