#value!

[Brickcounter]

In a1 I have alink to a cell on another page in the workbook.
In b1 the formula a1/100.
When I edit the cell ref in a1, b1 returns #value!
I don't understand why, and I can't seem to do anything about it.
Advice please.tia

 

[Ragdyer]

Exactly what is the linking formula in A1?

When you say "edit the cell reference" in A1, what (how) exactly are you
doing?

 

[Brickcounter]

A1 entry is =AllinOne!$Q$43
I edit in the formula bar to =AllinOne!$G$65

 

[Peo Sjoblom]

You must have a text value in G65, what happens if you put this in an empty
cell

=ISTEXT(AllinOne!$G$65)

if it returns TRUE you have text there

 

[Brickcounter]

Yes it is text, but my worksheet returned the numeric value before I did the
edit.
Worksheet allinOne is a downloaded webpage, and it is the numbers that I am
trying to enter (and process) on another page.
I am changing the references because the webpage has been rearranged and the
numbers I want are now in different cells.
I can't understand why it worked before, and it doesn't now.

 

[Peo Sjoblom]

Maybe the new one has trailing html characters


=--TRIM(SUBSTITUTE(AllInOne!$G$65,CHAR(160),""))


if that will work you have either html characters or spaces

 

[Brickcounter]

Yes that worked. Thanks Peo

Maybe the new one has trailing html characters


=--TRIM(SUBSTITUTE(AllInOne!$G$65,CHAR(160),""))


if that will work you have either html characters or spaces