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

    Working...
    X