dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
561
share rss forum feed

SipSizzurp
Fo' Shizzle
Premium
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.



MSeng
Premium,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.


SipSizzurp
Fo' Shizzle
Premium
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.


SipSizzurp
Fo' Shizzle
Premium
join:2005-12-28
Houston, TX
kudos:4

Click for full size
 
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.


Msradell
P.E.
Premium
join:2008-12-25
Louisville, KY
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.


SipSizzurp
Fo' Shizzle
Premium
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 !!



MSeng
Premium,Ex-Mod 2001-08
join:2000-07-13
Ork
kudos:6
reply to SipSizzurp

Click for full size
I can make them all night long -- 2010 version with all updates applied.
--
A)bort, R)etry, I)nfluence with large hammer.

PentiumIII

join:2002-06-28

1 recommendation

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.


SipSizzurp
Fo' Shizzle
Premium
join:2005-12-28
Houston, TX
kudos:4

4 edits
reply to SipSizzurp

Thanks for the extra tip, and thanks to you too MSeng See Profile for helping Msradell See Profile hit the nail on the head.



Grey Area

join:2003-11-18
UK
reply to SipSizzurp

And I seem to remember if you want it centered, you can type

^=