I need to format numbers for displaying Euros with €###.###,##
This is contrary to the typical USD number format and uses a period where USD would typically use a comma and a comma where USD would typically use a period.
I try to set up a custom format in the universe and or in a report and BO appears to immedidately interpret the period as it would with USD as opposed to the European format.
I’m using XI 2.1
Any assistance would be appreciated.
darwin (BOB member since 2008-06-26)
I’m not sure exactly what you are looking for, but can suggest the following. In your format, # is an optional character, and 0 is a mandatory character. For example, if I format the number 64 as $0,000, it will show up as $0,064. If I format 64 as $#,##0, it will show up as $64. Does that help?
MichaelWelter 
(BOB member since 2002-08-08)
I want the number 1000.45 to show up as 1.000,45
darwin (BOB member since 2008-06-26)
OK, try the format as 0.000,##.
MichaelWelter (BOB member since 2002-08-08)
Once you enter the period in the format it interprets it as the decimal point
€0.000,## displays as €1234.456 it puts 3 places after the decimal point and appears to ignore the use of commas completely.
darwin (BOB member since 2008-06-26)
Hmmm . . . try €0.000,00 and see what that does.
MichaelWelter (BOB member since 2002-08-08)
It behaves similarly except it puts 5 places after the decimal point instead of 3.
Hopefully a European user will have a look at this and have a solution.
Thanks for your help.
darwin (BOB member since 2008-06-26)
Try €#,###.00 format.
Rakesh_K 
(BOB member since 2007-12-11)
darwin,
Webi help says that “.” is used as a decimal separator and “,” is a grouping separator.
So your format string should look like €#,###.00
Characters actually being put into a formatted string fully depend on your locale. If you want your report to keep the formatting you see for all other users, check the appropriate flag in the document properties.
Dmitry Grekov 
(BOB member since 2009-09-29)
I figured it out. In Infoview the Interface Locale needs to be set to Italian in order to format Euro amounts correctly.
darwin (BOB member since 2008-06-26)
Well, that’s certainly intuitive. 
Good job!
MichaelWelter 
(BOB member since 2002-08-08)
Hello,
Good solution. But how to handle below case:
Customer wants default preferred Infoview Locale in ENGLISH. But i have one specific report which needs to be shown Numbers in EURO format (ex:2.356.000,00 € ) for a specific report only.
How can I achieve this for a specific report?
I already tried with formatnumber, changing Object formatting properties at Universe/Webi report level but it doesnot work. Is there any specific formula?
I believe this must be standard requirement for global reports!!!
chaithu1983 (BOB member since 2009-05-19)
No, it’s not standard. Standard English format is €1,234.56 not €1.234,56
Several European nations use €1.234,56 but not English speaking countries.
We should move to a global currency, like Earth Credits 