Even though Excel environment settings will automatically change to European format when required you may want to use this format which ever world region you are in.
The following edit codes will force Excel to always display European formats.
1 ,00
2 \,00
3 #\,00
4 ##\,00
5 ###\,00
6 ##\,00
7 ###\,00
8 ###\.###\,00
9 ###\.###\,00
10 #\.###\.###\,00
11 ##\.###\.###\,00
The number preceding for edit code indicates the length of the data.
Article ID: 23, Created On: 4/1/2014, Modified: 4/1/2014