Export to Excel – Leading zeros get removed in numbers

[#1]

Hello -

When users export to Excel, the leading zero's in a numbers get truncated. Any idea of how to adjust this so it does not happen? An example would be an invoice number in QlikView - 000456789, Excel 456789.

Cheers!

Chad

[#2]

Hi,

While exporting, it exports Invoice number as number and hence removes leading zeroes.

I don't know how to restrict such export but...

If you want them, you can do it in excel in a very simple manner.

Select complete column of Invoice Number, go to format cells- Number format-Custom and write maximum number of leading zeroes possible in individual invoice number.

You will get what you want.

Happy Thoughts

[#3]

You could use the text([FieldName) to force your invoice numbers to be text values. When you export to excel, the leading zeros will be maintained.

Nimish

[avinashelite]

its the common issues we have while exporting try like this

*Convert the number format to text like Text(field_name)

[hectorgarcia]

I tried your advise but is not working, should be something with excel that convert the text(field) in number