How do you replace a yes value in a cell with a check mark?

[Guest]

I have certain cells in a worksheet that contain the word YES. I would like
to replace the word YES with a check mark.

 

[Guest]

try, Alt+0124

(numbers must be entered from the number keypad). Then change the font to
symbol.

 

[Guest]

hi,
another way...
Format cell to font Marlett. enter lower case a.

Regards
FSt1

 

[Guest]

Edit > Replace > Find what: yes > Replace with: P > Replace
Format cell as Wingdings 2

 

[Guest]

See

http://office.microsoft.com/en-us/excel/HA011166011033.aspx

For several ways to do this. Some have been suggested by the other posters.

/Sune

 

[Guest]

Or, just for fun, use a macro:

Sub checkmark()
If ActiveCell.Value = "YES" Then
With ActiveCell
.Value = "ü"
.Characters(Start:=1, Length:=1).Font.Name = "Wingdings"
End With
End If
End Sub

You could add this to the worksheet code to make it automagic og just use a
shortcut.

/Sune