View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Extra spaces???
Pasting from a web page??? (Maybe extra non-breaking spaces (HTML stuff))

Cell formatted as text??

If it's the non-breaking spaces stuff, visit David McRitchie's site for a
routine that will clean them up:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

If you still can't find the problem, visit Chip Pearson's site and get his
CellView addin. It should help you check character by character.

http://www.cpearson.com/excel/CellView.htm

Randberger wrote:

I'm a rookie trying to use the statistical analysis tools. When I try to
enter data, I get a warning that my input contains non-numeric data; however,
it sure looks like numeric data to me. No text, etc. Any help?


--

Dave Peterson