#value!

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
 
R

Ragdyer

Exactly what is the linking formula in A1?

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

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
 
B

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.
 
P

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
 
B

Brickcounter

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...
 
Top