| How Format upto 2 decimal places by put_cell [message #436977] |
Wed, 30 December 2009 01:10  |
sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI
|
Member |
|
|
Dear Gurus,
i am using rpt2xls.put_cell(1,:amount,null,null,0,null,null,null,-4108);
for converting into excel.
But i am getting output as 100,200,300 e.g
desired output is 100.00,200.00
for this what i have to do please give me suggession or possible codes.
Note: I have already made format mask in pdf as 999999.99
but in excel it is not comming as required.
regards:
Sunil Madnani
|
|
|
|
| Urgent : format number upto 2 decimal places using ole2.put_cell [message #437129 is a reply to message #436977] |
Thu, 31 December 2009 03:15  |
sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI
|
Member |
|
|
Dear all,
i want to format a field which is of number type. It should be dumped in excel as formatted up to 2 decimal places .
i am using rpt2xls.put_cell(1,:amount,null,null,0,null,null,null,-4108);
current output :100
expected output :100.00
It is very urgent please revert back with example or sample code.
Note: I am attaching a RDF for exapmple. In this i want F_trnsprt_hndlg_chrg to be formatted upto 2 decimal places in excel.
Regards:
Sunil Madnani
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
