Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

I can't put a % in an excel cell

Wierd, I can type in jibberish letters like "asfaslkdf" and the cell shows what I just typed.  However, if I put in the % symbol, I get "%2"

I cannot figure it out.

I deleting the entire column and added a new one--still no luck.

EE rocks.
0
dorianit
Asked:
dorianit
  • 5
  • 2
  • 2
  • +2
6 Solutions
 
NBVCCommented:
Can you check the formatting of the cell?  It probably is format as "%General" or similar.
0
 
Martin LissOlder than dirtCommented:
Is the row formatted?
0
 
Alan HardistyCo-OwnerCommented:
Type:

'%

and you should see just the % sign displayed.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
dorianitAuthor Commented:
'% produces %2

The cell is set to General

Another thing, when I press enter on that cell, it goes and updates all my queries because I have external data connections.  I can't find which formula is referencing this cell....argh
0
 
NBVCCommented:
There is probably a macro... right click the sheet tab, and select View Code... check if there is any code there that might be converting the formatting....

You can find dependent/precedent cells in Formulas tab, Trace Precendents, Trace dependents
0
 
Gašper KamenšekExcel MVPCommented:
What do you get if in the cell where you want 20% you just write 0.20 and then press
Ctrl+Shift+5   (the 5 in the alphanumeric part)

Should get what you want (20%)

Good luck
0
 
dorianitAuthor Commented:
NB_VC,

I hoped your suggestions would help find the problem, unfortunately no.  I viewed the code and the dependents.  I got an error saying there is not formula.

this is strange...

I'll close excel and come back in.
0
 
dorianitAuthor Commented:
closing excel and reopening the file did not help...
0
 
Martin LissOlder than dirtCommented:
Can you attach your workbook?
0
 
dorianitAuthor Commented:
No, I can't.  Sory.
0
 
dorianitAuthor Commented:
....I made a workaround by typing %' and then making the tick color the same as my background.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now