#VALUE!

  • Thread starter Thread starter Cameron
  • Start date Start date
C

Cameron

Can anyone answer this: When i paste in info from a web
site, one of the columns contains numbers, yet when I try
to refer to those numbers in formulas in other cells, it
always comes up with the #VALUE! message, as though it
were text in there, not numbers. Any ideas?
 
Can anyone answer this: When i paste in info from a web
site, one of the columns contains numbers, yet when I try
to refer to those numbers in formulas in other cells, it
always comes up with the #VALUE! message, as though it
were text in there, not numbers. Any ideas?
Click to expand...

This is possible. Sometimes numbers get pasted in Excel as text and cannot
be used as numbers in formulas afterwards. (It might even happen if the
formatting of the cell is set to number, and not apparently to "text".)

If you enter the cell and exit it with the "Enter"-key, it might happen
that Excel changes the formatting from text to number and then you can use
the values again. To circumvene this, you could use the formula
"Value("string containing only numbers")"

CoRrRan
 
See a couple of replies to your other post.
Can anyone answer this: When i paste in info from a web
site, one of the columns contains numbers, yet when I try
to refer to those numbers in formulas in other cells, it
always comes up with the #VALUE! message, as though it
were text in there, not numbers. Any ideas?
Click to expand...
 
Back
Top