XanderJose
asked on
Decimal number problem from rpt to excel
A database field {Price} , IF one actual record is 1234.56 , I want it is 12345.00 .(rount 5) I do some settings through field format number.
After I export it to excel , I noticed the field is 12345.00 but when I double-click the cell , it became to 1234.56 (Actual value)
I want it is 1235.00 , how to do it ?
Crystal Report v11.5
After I export it to excel , I noticed the field is 12345.00 but when I double-click the cell , it became to 1234.56 (Actual value)
I want it is 1235.00 , how to do it ?
Crystal Report v11.5
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome. Glad I could help.
FWIW, another option would be to replace the field in the report with a formula that rounds the value.
Round ({your field})
James
Round ({your field})
James
ASKER