November 4, 2013 at 2:23 pm
Goal:
Display the number in Swedish format that is "50 000 000,50" instead of 50,000,000.50 in a list containing cells.
Problem:
I have tried using "## ### ###,##" but it didn't work at all.
Any suggestion?
Information:
*I'm retrieving the data from a SSAS data source.
November 4, 2013 at 4:43 pm
The standard way would be to use the format property with a value of "C2", then it will use the user's local region settings to display the value.
If you wanted to force Swedish, then also set the "Language" property on the textbox to sv-FI (or some other suitable value).
This does add a currency symbol though, so if you just want the number, you could try "N2" instead of "C2"
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply