Announcement

Collapse
No announcement yet.

How to change excel output of a report from English international format to regional

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to change excel output of a report from English international format to regional

    Hi Team,
    We have an reports which has dot as a separator for numerals having decimals.
    Is there any way to change it to comma instead.
    Also is there any way, that based on language selected for MS office, excel automatically changes commas to dots and vice versa.

  • #2
    Re: How to change excel output of a report from English international format to regio

    Hello Neha

    You can use below query to achieve this,
    to_char(123456.789,'999999999D00','nls_numeric_cha racters=,.')

    Please click on thanks if you feel this post as useful.

    Regards,
    Akshay

    Comment


    • #3
      The locale code should be enclosed in [square brackets] and preceded with the dollar sign ($) and a dash (-). Here are a few examples:

      [$-409] - English, Untitled States
      [$-1009] - English, Canada
      [$-407] - German, Germany
      [$-807] - German, Switzerland
      [$-804] - Bengali, India
      [$-804] - Chinese, China
      [$-404] - Chinese, Taiwan

      by accounting and bookkeeping services in dubai

      Comment

      Working...
      X