I have a spreadsheet that is linked to an Access database. The spreadsheet contains a column that are filled in with an identifying number (record ID), but must be recognized as text.

The only way Access will recognize this column containing numbers as text is to precede the number with a single quotation ( ' ).

Is there a way to concatenate or somehow embed the single quotation so that the user doesn't have to remember to do this? I only need this entered one time on the spreadsheet. I tried building a concatenate formula [concatenate ("'",B2), but this fails to produce the desired results.