Replace -1 with a tick symbol

T

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
 
G

Gary''s Student

Use find/replace


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

Tom

Hi Gary

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

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
 
D

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
 
D

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

mr.davidmorrison

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