Can't insert % symbol in Excel 2016


A user suddenly can't write the % symbol when entering text in a cell in Excel 2016 under Windows 7

Any ideas what might be causing this ?

Yann ShukorOwnerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Darrell PorterEnterprise Business Process ArchitectCommented:
Check to ensure there is no formatting on the worksheet which would prevent the "%" sign from being typed.
Create a new workbook and determine if you can enter a "%" symbol within a cell by type '23%' in cell A1.  If you can, the workbook in which you cannot probably has a formatting issue or cell protection of some sort.
When the user attempts to enter a '%' symbol, do they receive an error?
Yann ShukorOwnerAuthor Commented:
Thanks Darrell
I tried it on a new blank worksheet without success
No error
Darrell PorterEnterprise Business Process ArchitectCommented:
Not trying to be a smartaleck here...

can you copy and paste the


into a cell?
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Yann ShukorOwnerAuthor Commented:
yep, that worked

Not meaning to be too basic, but trying to narrow this down:

1) Can they type % into, say, Word (or any other application than Excel 2016)?  If not, then try replacing their keyboard.

2) Can they type all other symbols into Excel 2016 such as ! @ # $ ^ & without any issues?

3) Did this just start happening, and if so, has anything changed (apart from this) between it working and now?

Suggestion:  You could just try doing an Office Repair.  No particular reason to think that will work, but no harm in trying.

Yann ShukorOwnerAuthor Commented:
Tried with Word : same result, can't type the % symbol
It isn't a physical keyboard issue because I'm connected to the PC via Teamviewer
Tried to repair Office, Quick and Online : no improvement
Yes, other characters work fine
Even the onscreen keyboard is unable insert the % or ù (it's lower case counterpart)
I didn't mention that this is a french Windows 7 (AZERTY) with Bulgarian and Russian MS-Office language plugins
If however I type Alt + 37 then the percent symbol appears on the screen

Same thing anywhere in Windows e.g. notepad, so it isn't an MS-Office issue, but Windows issue

This key (%/ù) works fine with US keyboard layout, therefore I might have narrowed it down to the
French (AZERTY) keyboard layout as the source of our problem  

Removed the french keyboard support, rebooted, then added french keyboard support again and tested the key : issue remains unresolved
is the problem recent?   then a system restore to such date can help you
Yann ShukorOwnerAuthor Commented:
Yes this is a recent issue
I contacted Microsoft support this morning (chat) and they indicated that it would be necessary to reinstall a driver
The support person offered to help me out via a remote access but I had to cut this attempt short because the person was taking forever to handle this this update...the user had arrived and was waiting to use her PC
Hi Yann,

I'm not sure why Microsoft would think this is a driver issue - nothing above that you have set out says that to me?  What was the reasoning behind that?

What happened why you tried the system restore as was suggested above?



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Not sure that my answer should be the best one - happy to continue trying to help resolve the problem though.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 7

From novice to tech pro — start learning today.