Skip to main content

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

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


Terms & ConditionsCookie settings