My Oracle Support Banner

Export To Excel from ORMB Looses Some Format (Doc ID 2779395.1)

Last updated on APRIL 27, 2023

Applies to:

Oracle Financial Services Revenue Management and Billing - Version and later
Information in this document applies to any platform.


On RMB v2. against FW v4.3.0.6, when I export data from RMB UI to Excel, format shown on screen is getting dropped when data is displayed in Excel sheet.
Followings are the example of this format mismatch:

- 00000053001192 exports to excel as 53001192. Leading zeros are dropped.
- 686561560945 exports to excel in scientific format 6.86562E+11.
- 2017‑05‑18 exports to excel as 5/18/2017.
- Number 16.20 on screen shows 16.2 on excel.

How to display them as is in Excel?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.