"stuck" wrote:
I need to be able to add an apostrophy in front of numbers in a range of
existing cells without having to type it into each cell. I am trying to
set
up a spreadsheet that I can import into accpac and I need to have the
apostrophy there.

I wonder if the apostrophe prefix is sufficient, much less necessary.

How do you save the worksheet so that it can be imported into ACCPAC?

If you save the worksheet as a ".csv" file, note that apostrophe prefixes
are not recorded in the CSV file. The CSV file makes no distinction between
cells with numbers and cells with numeric text, even if you format the cell
as Text.

However, numeric text within double-quotes (literally "123") is recorded in
the CSV file in a distinctive manner.