Thanks you all for your help - works a treat.

Tom

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43E5F046.D32DE11A@verizonXSPAM.net...
> Select your range
> edit|replace
> what: -1
> with: =char(252)
> replace all
>
> If you don't want the formula, select that range and
> edit|copy
> edit|paste special|values
>
> Tom wrote:
>>
>> Hi Gary
>>
>> Thanks for your reply but its not the ' character I want to use but the
>> 252
>> character which is ü
>> Tom
>> "Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in
>> message
>> news:460C2471-1EB7-4053-B2C6-6ACBEBFFAD70@microsoft.com...
>> > Use find/replace
>> >
>> >
>> > 1. pull-down: Edit > Find and enter -1
>> > 2. pull:down: Edit > Replace and enter '
>> > --
>> > Gary''s Student
>> >
>> >
>> > "Tom" wrote:
>> >
>> >> Hi
>> >>
>> >> Any advice on the following would be appreciated:
>> >>
>> >> Using Excel 2003, am importing a table from MSAccess to Excel, 2 of
>> >> the
>> >> Access field are Yes/No with -1 as the affirmative. When imported to
>> >> excel
>> >> would like to be able to replace the -1's with a tick
>> >>
>> >> TIA
>> >>
>> >> Tom
>> >>
>> >>
>> >>
>
> --
>
> Dave Peterson