SipSizzurpFo' ShizzlePremium
join:2005-12-28
Houston, TX
kudos:4 | [Excel] Excel 2010 is Freaked In Excel 2010 I would like a cell to have the equal sign, that looks like this =
When I put an = in the cell it looks fine until I move to the next cell. Then Excel changes my = to =g27. If I correct it back to = it again changes it to =g27. Then entire column is formatted as "Text Only". Various other cell formatting options result in the same or other errored displays.
I cannot make the = sign stay as typed.  !#@$!
--
Breaker One Nine. |
|
 MSengPremium,Ex-Mod 2001-08
join:2000-07-13
Ork
kudos:6 | Try right click Format Cells...-->Custom-->General
--
A)bort, R)etry, I)nfluence with large hammer. |
|
SipSizzurpFo' ShizzlePremium
join:2005-12-28
Houston, TX
kudos:4 | Same result, but that changes the = to =F29 and this is cell F-29.
--
Breaker One Nine. |
|
SipSizzurpFo' ShizzlePremium
join:2005-12-28
Houston, TX
kudos:4 | Random oddities, but cannot get a plain equal sign to stay put. No amount of cell formatting resolves. Office 2010 SP1.
Edit - I just started again with a blank file with same results. Can anybody with Excel 2010 verify that they can make an equal sign stay just an equal sign after leaving that cell ?
--
Breaker One Nine. |
|
 MsradellP.E.Premium
join:2008-12-25
Louisville, KY
 ·AT&T U-Verse
| reply to SipSizzurp
I can put = in a cell I want to, hit enter which moves the cursor down in that cell stays exactly like it was with just the =. I tried it formatting the cell as text and without formatting it and had the same results. Your problem is because you're not hitting enter so excel thinks you're starting a formula. When you hit enter it closes out the function. |
|
SipSizzurpFo' ShizzlePremium
join:2005-12-28
Houston, TX
kudos:4 | You are correct. I was not hitting enter, but hitting enter does resolve the problem. I was mouse clicking away from the cell.
Thank you very much !! |
|
MSengPremium,Ex-Mod 2001-08
join:2000-07-13
Ork
kudos:6 | reply to SipSizzurp
I can make them all night long -- 2010 version with all updates applied.
--
A)bort, R)etry, I)nfluence with large hammer. |
|
| reply to SipSizzurp
or try this, put the single quote in front of whatever you want to keep as text, in your example like this
'=
then you can navigate away or hit enter should leave you with just the = sign. |
|
SipSizzurpFo' ShizzlePremium
join:2005-12-28
Houston, TX
kudos:4
4 edits | reply to SipSizzurp
Thanks for the extra tip, and thanks to you too MSeng  for helping Msradell hit the nail on the head. |
|
| reply to SipSizzurp
And I seem to remember if you want it centered, you can type
^= |
|
