Solved

I can't put a % in an excel cell

Posted on 2013-06-13
11
257 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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

939 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now