Issue with Prefix Zero for a values when downloading a report in excel Format in OBIEE

In OBIEE , Generally we came the issue with the values having prefix Zero for any attribute.For examples, The report contains column called Item codes which have a value like "00715423".So when you download this report in the excel format then the values under the item code will looks like "715423".

Example: The report looks like as shown below.

When we downloads it to excel then the same will looks like below.

Here, we have noticed that values starting with zero causing the problem. Please follow the below steps to overcome this issue.

We have to change the format of this column to text explicitly by adding the code in the Edit formula section.

After adding the above code and now change the data format to HTML.

Now the run the report and extract to excel. The report will looks good with the values having prefix zero.