Leading Zeroes suppressed of Excel download in obiee

To avoid the leading space or blank you can do something like this. Add this to the formula and format the column as HTML. 

'<div style="mso-number-format:\@">' || "Table Name"."Column Name" || '</div>'

Work around is: Add following code in fx and make your data format as: HTML.

'<span style="display:none">&nbsp</span>' ||  'YourColumn'