Skip to Content
0
Former Member
Nov 30, 2004 at 05:42 AM

Decimal places to 2

19 Views

Hi All,

I have retrieved data from BSIK and when displaying the DMBE2 field (the amount field), on the list screen for certain records which have after decimal place single value ex 54.20, the value displays as 54.20 which is fine but when downloaded to excel it shows as 54.2

So, i highlighted the DMBE2 column and from the menu FORMAT-->Cells, under the NUMBER tab checked the number and set the decimals to 2 and when said OK, the excel format changes to the format that is required i.e 54.20 (with the zero added)Is there any other way that this can be done while downloading it to the excel , without any manual correction on the excel.

Thank you,

- Sravan