Show number value in Switzerland currency format

Show number value in Switzerland currency format

Posted by: adityav on 25 May 2023, 3:19 am EST

• 

  adityav

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 May 2023, 3:19 am EST

  I am using ‘$ #,##0_’ number format to display number with $ sign before the number($ 25000).

  In a similar way i was looking if i could show the number in Switzerland currency format like “25000 CHF” in the spreadjs spreadsheet cells. Is there a format to achieve this?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 25 May 2023, 11:17 pm EST - Updated 25 May 2023, 11:22 pm EST

  Hi Aditya,

  You could use the #,##0\ [$CHF-100C] formatter for the Switzerland currency. If you also want to include the decimals, you could use #,##0.00\ [$CHF-100C].

  

  910×290 12.6 KB

  Sample: https://jscodemine.grapecity.com/share/lGl_TCNqQEuMHhvW3_-_qg/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.js"%2C"%2Fpackage.json"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Formatters Demo: https://www.grapecity.com/spreadjs/demos/features/cells/formatter/basic-formatter/purejs

  Kindly let me know if you face any problems.

  Regards,

  Ankit

• 

  adityav

  • Post Options:
  • Link
    Copy

  Posted 30 May 2023, 6:09 am EST

  Thanks. It worked.