• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • 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 LissRetired ProgrammerCommented:
Is the row formatted?
0
 
Alan HardistyCo-OwnerCommented:
Type:

'%

and you should see just the % sign displayed.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 LissRetired ProgrammerCommented:
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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