Weird !!

H3MSY · May 2nd, 2002, 02:02 AM

It may be a bug in my copy, but sometimes in excel I reference a cell in the normal way e.g. in cell a1 i type =f11 and the value gives me whatever is in f11. OK correct.
If I then change that to =f12 it just says =f12 in the cell !!! If I change it back to =f11 it now says =f11. No matter what I try it doesn't go back to just showing the value of the referenced cell.

Anybody experienced the same?!

Nobby · May 2nd, 2002, 02:07 AM

Have you accidentally inserted a ' in the cell before the = sign? This would force the cell to treat your entry as text rather than a function, which is what it seems to be doing.

H3MSY · May 2nd, 2002, 02:13 AM

No thats what i first thought,
When you F2 it does show a ' but if you delete this it still gives the same result.
On the S/Sheet I'm in at the moment it even does it when you press f4 to put the "$" signs in. e.g =a1 gives a value of 2, press f4 and it shows =$a$1 ???????

philR · May 2nd, 2002, 02:26 AM

Have you formatted the cell to text? Go into format - cell and change it to "general". You will then have to remove the ' from in front. Hope this is it, or it really is weird!

H3MSY · May 2nd, 2002, 02:38 AM

Cheers Phil,

Thats sorted it. I'm going to blame it on the person who set the original sheet up. Wasn't me - Honest

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 02:02 AM	#1
H3MSY Board Regular Join Date: Apr 2002 Location: ENGLAND Posts: 62	It may be a bug in my copy, but sometimes in excel I reference a cell in the normal way e.g. in cell a1 i type =f11 and the value gives me whatever is in f11. OK correct. If I then change that to =f12 it just says =f12 in the cell !!! If I change it back to =f11 it now says =f11. No matter what I try it doesn't go back to just showing the value of the referenced cell. Anybody experienced the same?!

May 2nd, 2002, 02:07 AM	#2
Nobby Board Regular Join Date: Feb 2002 Location: United Kingdom Posts: 68	Have you accidentally inserted a ' in the cell before the = sign? This would force the cell to treat your entry as text rather than a function, which is what it seems to be doing.

May 2nd, 2002, 02:13 AM	#3
H3MSY Board Regular Join Date: Apr 2002 Location: ENGLAND Posts: 62	No thats what i first thought, When you F2 it does show a ' but if you delete this it still gives the same result. On the S/Sheet I'm in at the moment it even does it when you press f4 to put the "$" signs in. e.g =a1 gives a value of 2, press f4 and it shows =$a$1 ???????

May 2nd, 2002, 02:26 AM	#4
philR Board Regular Join Date: Feb 2002 Location: Sheffield, UK Posts: 249	Have you formatted the cell to text? Go into format - cell and change it to "general". You will then have to remove the ' from in front. Hope this is it, or it really is weird!

May 2nd, 2002, 02:38 AM	#5
H3MSY Board Regular Join Date: Apr 2002 Location: ENGLAND Posts: 62	Cheers Phil, Thats sorted it. I'm going to blame it on the person who set the original sheet up. Wasn't me - Honest