I'm hoping someone can help. I have a table loaded into QV11 with the following values:
The institution code field values pull correspond to the full institution name. However, when I send the table to excel, I get the following:
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).