Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

While downloading to excel Decimal places

Former Member

‎10-13-2008 7:06 AM

0 Kudos

Hi All,

I am uploading report output to application server. In report output there are 4 currency fields. In report output it is showing the decimal places correctly. But in downloadble fine it is showing round figures.

I am displaying the currency only for USD. I need to display the currency with two decimal places.How to do this ? can you please suggest me?

Advance thanks,

4 REPLIES 4

madan_ullasa
Contributor

‎10-13-2008 7:08 AM

0 Kudos

Hi,

Re check the value you are passing to transfer statement.... Is it passing with decimals or not??? Since the values are passed as characters it should not be truncated....

regards,

Madan...

Former Member

‎10-13-2008 7:14 AM

0 Kudos

Hi,

In ur excel select the field with values which display currency, right click and click on Format cells, click on Tab Number and select category Number and Decimal places 2 and click on ok.

Regards,

Amit

Former Member

‎10-13-2008 7:23 AM

0 Kudos

Hi,

In UNIX file it is showing round figures. But i need to display with decimal places.

madan_ullasa
Contributor
In response to Former Member

‎10-13-2008 7:25 AM

0 Kudos

Hi,

This should be an settings in your external file reader.

rgds,,

Madan..