A format string that begins with a dollar sign, such as $#,##0.00, causes the currency character to be localized based on the locale of the Teradata OLAP Connector machine running the BI client application. If the value really is in dollars, use a backslash before the dollar sign, such as \$#,##0.00, to force the dollar sign to remain even on a machine with a different operating system locale. For information on format strings, search for format string contents (MDX) in the MSDN Library at http://msdn.microsoft.com/library/.
Manually changing the format string from $#,##0 to €#.##0 does not cause mathematical currency conversion.
Only Excel 2007 and later support cube schema-specified format strings. Excel does this by always including a CELL PROPERTIES clause in the query to the database. If no server side formatting properties are specified for a measure, then the database only returns the VALUE property. Excel 2003 and earlier does not include this CELL PROPERTIES clause in its database query, and always uses the default cell formatting specified in the workbook.