Field values changing upon 'send to excel'

[mattphillip]

I'm hoping someone can help. I have a table loaded into QV11 with the following values:

Name	Institution Code
Joe	0018
James	0003
Jill	0102

The institution code field values pull correspond to the full institution name. However, when I send the table to excel, I get the following:

Name	Institution Code
Joe	18
James	3
Jill	102

Does anyone have any idea on how to retain the zeros?

I had previously attempted to map the corresponding value within QV but as some of the values for different fields are the same (for example N/A, 1, A1), the mapping was incorrectly adding values from the wrong fields. Hence, the export and lookups (unless someone knows how I could get the mapping to work? Please note that the actual data has 12.5 million row and approx 30 columns).

Any help would be greatly appreciated.

Matt

[sinanozdemir]

Hey Matt,

Maybe try to enforce the text format like the below:

You can also use Text() in the front end as well.

Hope this helps.

[Clever_Anjos]

Not sure about what´s happening there. Here is ok, please find attached my sample