Numbers formatted as text have to be converted back to numbers.
Create a range of cells in the same shape as the problem data cells,
each of which contains a 1. Then Copy this range, select the top-left
cell of the problem data range, select Paste Special from the Edit
menu, click on the Multiply button in the Operations section of the
Paste Special dialog, then click OK. Your numbers will now be treated
as numbers by Excel.

Mark Lincoln

On Apr 24, 1:18 am, Nickman wrote:
"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.- Hide quoted text -

- Show quoted text -