Skip to Content
author's profile photo Former Member
Former Member

Xcelsius 2008 - Excel TEXT Function Problem

Hi forum,

I hope someone can help me as this text formatting in Xcelsius 2008 is driving me mad!

I want to display numbers in an abbreviated format. So for the value £4,572,623.00 is want to display the value £4.57M.

In my example below, cell P48 gets it's value from a vlookup. but I will simplify this and simply pass a number into cell:

P48: 4572623

P63: =TEXT(P48,"£#0,,.00")&"M"

Cell P63 displays the value £4.57M.

I now create a value/textbox in Xcelsius and then link this to cell P63. It displays the correct value of £4.57M. When I generate the SWF or view it in Preview mode the number changes to £4,572,623.00M. Wierd thing is, It appears correctly as £4.57M in Designer mode. Even if I refresh my XML mappings in Excel the data still looks correct in Designer mode.

Your assistance would be greatly appreciated.

Regards,

Chris

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 14, 2011 at 10:25 AM

    Hi try this,

    d1: 4572623

    e2:=D1/1000000--->4.572623

    F2:=ROUND(E2,2)

    G2:="£"&F2&"M"

    mapp this to label in xcelsius and check .

    Hope this works.

    @Sri

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Sri,

      Your a star! I have had the Grid tool disabled in the past, but just couldn't for the life of me think how to do it again!

      Just for the forums information, I slightly adjusted your formula as when the value was zero, it would display £0M, and I would want £0.00M. Here is my final formula:

      ="£"&IF(ROUND(P$44/1000000,2)=0,"0.00",ROUND(P$44/1000000,2))&"M"

      Regards,

      Chris

      Edited by: cmcdonald on Jul 14, 2011 2:52 PM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.