Formatting the cells as Text doesn't work for your import?

--
Rick (MVP - Excel)


"stuck" wrote in message
...
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.