Post reply

Percentage format in excel2000/2002

  • March 6, 2010 at 4:09 am

    #217638

    Dear All,

    have used calulated member to arrive at percentage in ssas 2005.

    Percentage works well in excel 2007.

    but, when i try to browse it in excel 2000/2002 the percentage is not formating.

    need to manually format in older version. Pl let me know how to fix this.

    Eg

    0.0309 instead of 3.10%

  • March 6, 2010 at 6:02 am

    #1129614

    This is an Excel problem not a SQL problem.

    Search Technet for excel 2000 2007 differences and you will find about 2,400 articles ... explaining the different formats / how formulas are used, etc., etc.

    http://technet.microsoft.com/en-us/default.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply