Replace -1 with a tick symbol

[Tom]

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

 

[Guest]

Use find/replace


1. pull-down: Edit > Find and enter -1
2. pull:down: Edit > Replace and enter '

 

[Tom]

Hi Gary

Thanks for your reply but its not the ' character I want to use but the 252
character which is ü
Tom

 

[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

 

[Dave Peterson]

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

 

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

 

[mr.davidmorrison]

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

 

[Tom]

Thanks you all for your help - works a treat.

Tom