Format string issues in AS2005

[jeffmoore64]

Hi all,
I have 2 calc'd members one that has "#,#" as its' format string and another that has "percent"
I view the data 3 ways:
Excel 2000
Excel 2005
The cube browser.

The data for the "#,#" is presented as follows for each browser:
1234.56789
1,234
1,234

The data for the "percent" is presented as follows for each browser:
12.3456789
1234.56%
1234.56%

As you can see in both examples the format string is ignored in Excel 2000.

Any ideas how to address this problem?

Tia

 

[MDXer]

if memory servers me correctly you actually have to specify the format in excel 2k as it doesn't utilize the cube format strings. it has been years since I have used excel 2K against a cube.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[jeffmoore64]

Thanks. I figured so after fussing with it.