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

10|10000 characters needed characters exceeded

### Related questions

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

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