Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Display Swedish Format Expand / Collapse
Posted Monday, November 4, 2013 2:23 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 9, 2014 1:21 AM
Points: 58, Visits: 191
Display the number in Swedish format that is "50 000 000,50" instead of 50,000,000.50 in a list containing cells.

I have tried using "## ### ###,##" but it didn't work at all.
Any suggestion?

*I'm retrieving the data from a SSAS data source.
Post #1511301
Posted Monday, November 4, 2013 4:43 PM



Group: General Forum Members
Last Login: 2 days ago @ 2:30 AM
Points: 2,192, Visits: 7,773
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"


select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw
  • Post #1511325
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse