[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

I can't put a % in an excel cell

Posted on 2013-06-13
11
Medium Priority
?
263 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 660 total points
ID: 39245465
Can you check the formatting of the cell?  It probably is format as "%General" or similar.
0
 
LVL 49

Assisted Solution

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

Assisted Solution

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

'%

and you should see just the % sign displayed.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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 660 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 225 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 49

Assisted Solution

by:Martin Liss
Martin Liss earned 210 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

650 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