View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Nickman Nickman is offline
external usenet poster
 
Posts: 4
Default Why input range contains non-numeric data?



"Mark Lincoln" wrote:

On Apr 23, 9:06 pm, Nickman wrote:
When I try to do a regression analysis on my data, a box pops up saying there
is non-numerica data for the input. However, I cant find any within my data
sheet.


Are some of the cells formatted as text? Or entered with a leading
apostrophe (which amounts to the same thing)?

Mark Lincoln

I selected all of the data and then formatted the cells as numbered. And as far as apostrophes go I cant find any. But the problem still persists.