dorianit
asked on
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.
I cannot figure it out.
I deleting the entire column and added a new one--still no luck.
EE rocks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
closing excel and reopening the file did not help...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No, I can't. Sory.
ASKER
....I made a workaround by typing %' and then making the tick color the same as my background.
ASKER
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