European conversion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert Wheeler - 20 Sep 2007 14:44 GMT

I am wanting to know if it is possible to have a single workbook in Excel for
European presentations without having to do a global change for all workbooks
under "Control Panel"? I have used the toolbar conversion but it does not
change the comma to a period when displaying EU. The only way I have found
is to do a global change which changes all my workbooks. If there is another
way that only impacts the desired workbook that would be great.

Reply to this Message

Bernard Liengme - 20 Sep 2007 15:01 GMT

I assume you are not speaking of the date format (US mm/dd/yyyy vs
rest-of-world dd/mm/yyyy) since that is easy to fix with a custom format.
But numbers with a period as the thousands separator and a comma for the
decimal indicator cannot been done the custom format. You could use ### ###
###.00 to get a space for the thousands separator, I am sure most Europeans
would understand that.
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I am wanting to know if it is possible to have a single workbook in Excel
>for
[quoted text clipped - 6 lines]
> another
> way that only impacts the desired workbook that would be great.

Reply to this Message