Solved

I can't put a % in an excel cell

Posted on 2013-06-13
11
258 Views
Last Modified: 2013-06-14
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
Comment
Question by:dorianit
  • 5
  • 2
  • 2
  • +2
11 Comments
 
LVL 23

Assisted Solution

by:NBVC
NBVC earned 220 total points
ID: 39245465
Can you check the formatting of the cell?  It probably is format as "%General" or similar.
0
 
LVL 46

Assisted Solution

by:Martin Liss
Martin Liss earned 70 total points
ID: 39245473
Is the row formatted?
0
 
LVL 76

Assisted Solution

by:Alan Hardisty
Alan Hardisty earned 40 total points
ID: 39245491
Type:

'%

and you should see just the % sign displayed.
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

Author Comment

by:dorianit
ID: 39245501
'% 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
 
LVL 23

Accepted Solution

by:
NBVC earned 220 total points
ID: 39245541
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
 
LVL 10

Assisted Solution

by:GasperK
GasperK earned 75 total points
ID: 39245594
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
 

Author Comment

by:dorianit
ID: 39245602
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
 

Author Comment

by:dorianit
ID: 39245752
closing excel and reopening the file did not help...
0
 
LVL 46

Assisted Solution

by:Martin Liss
Martin Liss earned 70 total points
ID: 39245766
Can you attach your workbook?
0
 

Author Comment

by:dorianit
ID: 39245972
No, I can't.  Sory.
0
 

Author Comment

by:dorianit
ID: 39246435
....I made a workaround by typing %' and then making the tick color the same as my background.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question