Gary

Sorry it should be the check mark symbol which in the Excel help is shown as
ALT + 0252 which when I try to use ALT + 0252 gives the ü not the check mark
symbol

Tom
"Tom" <Tom@NoSpam.com> wrote in message
news:%237A9g3kKGHA.2304@TK2MSFTNGP15.phx.gbl...
> 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
>>>
>>>
>>>
>
>