Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number format in excel

Status
Not open for further replies.
craig322

craig322

MIS
Apr 19, 2001
108
US
Is there a way to set up a calculated member in a cube so that I can force the format the users see when bringing data into excel. If I set the Format String property to ##.00, it appears fine in the cube viewer, but when I bring the data into excel, it doesn't stop with two places to the right of the decimal point.

TIA
 
Status
Not open for further replies.

Similar threads

Motlatjo
  • Locked
  • Question
All Dimensions showing on Excel, but only 3 showing on SSMS
Replies
0
Views
161
Motlatjo
Motlatjo
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
160
juanvg1972
juanvg1972
edvmat
  • Locked
  • Question
Error in the conversion sql query
Replies
2
Views
233
edvmat
edvmat
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
293
Motlatjo
Motlatjo
burakcan
  • Locked
  • Question
How to rounding up to next integer value In MDX
Replies
0
Views
195
burakcan
burakcan

Part and Inventory Search

Sponsor

Back
Top