I export two Access tables to Excel all the fields are Y or N.
Table #1 is in text format
Table #2 is in number format

When exported to Excel Table #1 remains text - Y or N
But Table #2 changed to 1 or 2

Help-I need to change Tabel #2 to Text (Y/N) so I can merge (copy/paste) the
data into one...

Just changing the format of the cell in Excel does not change it to text.