ExcelBanter - keyboard characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - keyboard characters (https://www.excelbanter.com/excel-discussion-misc-queries/125649-keyboard-characters.html)

John

keyboard characters

I am trying to select rows which have a % included and insert a "1" in a
helper column so that I can sort, simple???
When I attempt to enter "%" into the formula I get "96". The fact that I can
write this mewans the shift 5 % key works.
Help please--
JOHNW

T. Valko

keyboard characters

Hmmm....

Check and see if there is an AutoCorrect setting for that:

ToolsAutoCorrect Options

Biff

"JOHN" wrote in message
...
I am trying to select rows which have a % included and insert a "1" in a
helper column so that I can sort, simple???
When I attempt to enter "%" into the formula I get "96". The fact that I
can
write this mewans the shift 5 % key works.
Help please--
JOHNW

All times are GMT +1. The time now is 06:49 AM.