Measure formatting in excel 2003

Is there a way to make my formatting on measures work in Excel?

Example:
I set format string in Visual Studio 2005 to #,# and then I expect to see a
number in excel as 1,000,000 but it is unformatted: 1000000

Is this possible?

Thanks in advance.
--

-M-

"Mikael" schrieb im Newsbeitrag


> Is there a way to make my formatting on measures work in Excel?
>
> Example:
> I set format string in Visual Studio 2005 to #,# and then I expect to see
> a
> number in excel as 1,000,000 but it is unformatted: 1000000

I observed the following: setting the FormatString in VS2005 to a number
format will work with Excel 2007. When accessing the same cube with Excel
2003 it will not work. So switching to Excel 2007 might be a solution.

However, also Excel 2007 has some problem regarding formatting. I still have
problems formatting a date in drill through.

Michael G. Schneider