Solved

I can't put a % in an excel cell

Posted on 2013-06-13
11
260 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 47

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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

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:Gašper Kamenšek
Gašper Kamenšek 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 47

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

726 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