how to maintain Data formatting after Union

[Anonymous]

I have a table which is a union of 2 tables ( A and B) - Table A contains values where as Table B Contains % value. I have a drop dop down filter with the values "Value" and "Percentage". So based on selection my unioned table will show correcponding data. how ever in the percentage select the values int hetable does not maintain "%" sign. Is there workaround so that I can get % sign in my Union table?