I am having a problem exporting data to excel.

[#1]

I have a column called CNAE has the following format 0000-0/00 in Qlikview it remains intact but when I export pro excel, some of them are in date formatting.

I've tried formatting the excel for number / general but the numbers are backwards.

[stevedark]

This will be an Excel issue, where it is messing up the data once it has received it.  If you change the format on the column to Text does it resolve the issue?

Sometimes these things are not simple to resolve properly, you could append a prefix on the field, eg CN:0000-0/00 to avoid Excel messing it up.

- Steve

[#3]

How do I do that for all data in that column?

[stevedark]

Your best bet is to do it at load time, replace the line where CNAE is loaded with,

'CN:' & CNAE as CNAE,

Or if you want to have both prefixed and un-prefixed versions you could do:

CNAE,

'CN:' & CNAE as CNAEPrefixed,

It is possible to add the prefix on just for a single chart, by clicking the Calculated Dimension button where you have CNAE as a dimension - but this is much less performant than doing it in the load script.

- Steve

[Clever_Anjos]

One trick that can help you

add an empty space before the CNAE

OR

add CHR(39) before the CNAE