Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 24th 07, 02:06 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 4
Default Why input range contains non-numeric data?

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.

  #2   Report Post  
Old April 24th 07, 05:17 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 227
Default Why input range contains non-numeric data?

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

  #3   Report Post  
Old April 24th 07, 06:18 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
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.

  #4   Report Post  
Old April 24th 07, 12:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 837
Default Why input range contains non-numeric data?

Reformatting a cell does not change the value in the cell, it merely changes
the display of that value. In particular applying a numeric format will not
change text into a number. Copy an empty cell, select the input range, and
Edit|Paste Special|Add to coerce the values into numbers.

To identify which cell(s) is(are) text,
Format|Cells|Alignment|Horizontal|General. Text will be left justified while
numbers will be right justified. Alternately COUNT() only counts numbers.

Jerry

"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.

  #5   Report Post  
Old April 24th 07, 03:08 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 14
Default Why input range contains non-numeric data?

If all your data look like numbers and still you have a problem. Excel need
to calculate with them to understand that its numbers. Try to write 1 into a
cell and Copy-Paste Special and multiply all the data. Then, it should work.
Alternatively you can hit F2 in every single cell. Same idea.
Gunnar

"Jerry W. Lewis" wrote:

Reformatting a cell does not change the value in the cell, it merely changes
the display of that value. In particular applying a numeric format will not
change text into a number. Copy an empty cell, select the input range, and
Edit|Paste Special|Add to coerce the values into numbers.

To identify which cell(s) is(are) text,
Format|Cells|Alignment|Horizontal|General. Text will be left justified while
numbers will be right justified. Alternately COUNT() only counts numbers.

Jerry

"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.



  #6   Report Post  
Old April 24th 07, 04:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 227
Default Why input range contains non-numeric data?

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 -



  #7   Report Post  
Old April 24th 07, 07:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 4
Default Why input range contains non-numeric data?

Ok, so I copied and pasted special with a blank box and a bunch of random
numbers in my columns went right justified while most stayed left. But that
didn't fix anything. Then I tried all of the other suggestions and still
nothing it working. I still have random numbers sitting on the right and
cant do any data analysis. This is getting frustrating.



Nickman

"Mark Lincoln" wrote:

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 -




  #8   Report Post  
Old April 24th 07, 09:58 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 14
Default Why input range contains non-numeric data?

I think you might have space infront or behind some of your data. Use F2 in
some of the cells to make sure that there not are any "odd characters"
unvisible.
You can check this easy also by using =Left(b1,6) where 6 is numbers of
characters
you want to extract.
This formatting problems is very irritating in Excel. Numbers are not always
calculatable(if thats a word) even if its seems like it.
Good luck
G.
"Nickman" wrote:

Ok, so I copied and pasted special with a blank box and a bunch of random
numbers in my columns went right justified while most stayed left. But that
didn't fix anything. Then I tried all of the other suggestions and still
nothing it working. I still have random numbers sitting on the right and
cant do any data analysis. This is getting frustrating.



Nickman

"Mark Lincoln" wrote:

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 -




  #9   Report Post  
Old November 1st 20, 05:11 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 1
Default Why input range contains non-numeric data?

This worked for me, copying my cells that should have been numeric but didn't act like it, and pasting special as values into a new sheet.
On Tuesday, April 24, 2007 at 6:54:02 AM UTC-5, Jerry W. Lewis wrote:
Reformatting a cell does not change the value in the cell, it merely changes
the display of that value. In particular applying a numeric format will not
change text into a number. Copy an empty cell, select the input range, and
Edit|Paste Special|Add to coerce the values into numbers.
To identify which cell(s) is(are) text,
Format|Cells|Alignment|Horizontal|General. Text will be left justified while
numbers will be right justified. Alternately COUNT() only counts numbers.
Jerry
"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.

  #10   Report Post  
Old November 16th 20, 11:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 1
Default Why input range contains non-numeric data?

On Tuesday, April 24, 2007 at 6:54:02 AM UTC-5, Jerry W. Lewis wrote:
Reformatting a cell does not change the value in the cell, it merely changes
the display of that value. In particular applying a numeric format will not
change text into a number. Copy an empty cell, select the input range, and
Edit|Paste Special|Add to coerce the values into numbers.
To identify which cell(s) is(are) text,
Format|Cells|Alignment|Horizontal|General. Text will be left justified while
numbers will be right justified. Alternately COUNT() only counts numbers.
Jerry
"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.
Thank you Jerry.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Input formulas in a defined data range and convert results as valu Tan New Users to Excel 0 April 18th 07 12:54 AM
sheet protection - only selected range to be able to select/input data Corey Excel Worksheet Functions 7 February 13th 07 06:41 PM
formula numeric input seamaml Excel Discussion (Misc queries) 1 January 10th 06 05:12 AM
How can I run a spreasheet over range of input data ? prego Excel Discussion (Misc queries) 0 January 6th 06 09:09 PM
How can I set a input range for entrying data. Intercorp Excel Worksheet Functions 1 October 6th 05 09:58 PM


All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017