My Oracle Support Banner

Leading Zeros are Missing in Microsoft Excel Output (Doc ID 2990776.1)

Last updated on DECEMBER 22, 2023

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 23 C Patch 6 and later
Information in this document applies to any platform.

Symptoms

When opening csv output in Microsoft excel, leading Zeros are erased for elements that are made up of all digits and start with leading 0's.

Example:

You have a part number with this value: 0012345. Perform a bulk download of this part. Upon opening the csv file in excel, observe the value gets truncated to 12345.

Cause

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
Symptoms
Cause
Solution


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