#value!

  • Thread starter Thread starter Brickcounter
  • Start date Start date
B

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
 
Exactly what is the linking formula in A1?

When you say "edit the cell reference" in A1, what (how) exactly are you
doing?
 
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
 
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.
 
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
 
Yes that worked. Thanks Peo

Peo Sjoblom said:
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
Click to expand...
 
Back
Top