Replace -1 with a tick symbol

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

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
>
>
>

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
>>
>>
>>

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
>>>
>>>
>>>
>
>

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

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

select webdings as your font then press A for checkmark
or R for X mark

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