I NEED A GENIUS

  • Thread starter Thread starter Inept
  • Start date Start date
I

Inept

OK Geniuses - show me what you're made of!!
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?
 
It sounds like you have some extra "stuff" in the cell.

Since it's coming from a web site, it might be non-breaking spaces (nice for
formatting--awful for excel's numbers).

Select that troublesome range and
edit|replace
find what: hit and hold the alt and type 0160 from the number keypad
replace with: (leave blank)
replace all

You may want to do the same with normal spaces (spacebar).

If that didn't work:

Select an empty cell.
Edit|copy
Select your range of offending cells
edit|paste special|check Add in the operation section.
 
OK here is what I think, you need to change the format on
the numbers because when you copied them they probably
were copied as text and you can not perform mathmatic
operations on text, you need to at least change them to
numbers.
 
Reformating changes the display, not the underlying value. In
particular, it will not change text into a number. You either have to
re-enter the value after reformatting, or follow J.E. McGimpsey's
directions.

Jerry
 
Back
Top