Hello,
I would like to format numbers in a quickteport like this 1.000,00. And they should be aligned right in the cell. And of course in excel. We use Apps9.
thank you for assist,
Hermann
Hi,
The digit grouping and other formatting in Excel is based on the region format settings in Windows. If you have a text string not being shown as a number in Excel you can convert it in the quick report sql with TO_NUMBER(your column) or your_column*1 or something similar.
BR
Johan
Userlevel 7
+21
I'm a big fan of using in these situation of the search string 'plsql format’. In this case I use https://www.techonthenet.com/oracle/questions/format_nbr.php which leads to, as you can see, to techonthenet. The site has helped me in numerous of occasions.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.