Put units to data in a data graphic

[vrouwtjeskip3]

Hi there

I want to put a unit after the data thats linked with  a ecxel sheet. I already know that I need to change it in the shapesheet, but I dont know where and with what code.
I already successful change the numbers after the comma with the code "=ROUND(10.000,1)". And i'm sure I need to get a unit also the, but i'm can't find it.

Greetz,
Henri   

Sorry for my bad enlgisch, I'm just a stupid dutch guy...

[Visio Guy]

Try something like FORMAT(Prop.SomeExcelValue, "0.00u")

the 'u' adds units. You can cast units by adding 0 of some unit, like this:

FORMAT( 0cm + Prop.SomeExcelValue, "0.00u")

but be careful, if Prop.SomeExcelValue has no units, then Visio will infer inches, so you might get weird values.

FORMAT(0cm + 1, "0.00u") => 2.54cm
FORMAT(0cm + 1cm, "0.00u") => 1.00cm
FORMAT(0mm + 1cm, "0.00u") => 10.00mm