You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Going mad here. I'm not trying to do anything difficult, just asking a worksheet (a form/specification) to pick up a piece of text from another worksheet in the same workbook.
I'm just using the ='worksheet2'!cellref format by typing = into the target cell and then clicking on the relevant cell in the second worksheet.
And it gives me the answer, the string of text
Until i move somewhere else in the worksheet at which point it then changes and instead of the answer gives me the formula! And it won't go back unless I delete it and set it up again. And then repeats?
Ideas? I can't decide if it's a glitch or I've got a total mental block....I'm usually pretty excel savvy.
I'm glad I don't have to use excel now.
*Looks at open Rstudio tab lovingly.*
cell format is 'text' rather than 'general' ?
calculation options set to 'manual' rather than 'automatic' ?
is it to do with cell formatting in your sheet - something using the top left "weird" key makes it toggle between showing formulae or values, doesn't it ?
tried both......
is it "just" text in the referred cell or is it a formula to retrieve it from elsewhere ? - if the latter, wonder if you'd be better rewriting the formula into your second sheet to perform the retrieval from the orginal source
You haven't hit CTRL-` by mistake have you?
Set the format to General, do the =#REF again, then if it plays silly B's delete the =, press enter then add the = back in - once Excel thinks a cell contains text it sometimes needs reminding that it's a formula
Press CTRL + ` (grave accent)
Edit: Hour late. Should have read the whole thread
clever (what does that do then?)
I like that!
Press CTRL + ` (grave accent)
That's what I was failing to describe earlier ("the weird key" is what ill-educated chimps call the grave accent)
what I was failing to describe earlier
Yeah, I know. But I didn't read anyone else's posts as I got all excited about knowing the probable answer
But I didn’t read anyone else’s posts as I got all excited about knowing the probable answer
Yeh, but it seems that yours worked whereas JV seemed not to know WTF I was wittering on about
That’s what I was failing to describe earlier (“the weird key” is what ill-educated chimps call the grave accent)
In computing terms, the character when it's on its own rather than over a letter is called a backtick.
didn't have a clue what scaredy was on about, but the purist probably deserves the credit except I missed that trying his other suggestion
Still don't know why it was doing it on some but not the others but toggling that back and fro seems to have fixed it.
Thanks all!
`¦¬)