I couldn't get alt-0252 to work in the Edit|Replace dialog, but after you put
that funny character in there, you'll have to change the font to wingdings.

Tom wrote:
>
> 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
> >>>
> >>>
> >>>
> >
> >

--

Dave Peterson