![]() ![]() Test the URL first,īeing careful to log out of the file-sharing website. If so, I suggest that you upload a redacted Excel file that demonstrates the problem (ideally before the changes that I suggested above) to a file-sharing website (e.g. box.net/files), and post the public/share URL in a response here. Copy those columns and paste-value into A1:B100.Īre any of the ISNUMBER results still FALSE? If so, the data might contain non-breaking spaces (HTML nbsp ASCII 160). If so, try to use the Data > Text To Columns feature for each of A1:A100 and B1:B100 separately.Īre any of the ISNUMBER results still FALSE? In parallel columns, enter the formulas =ISNUMBER(A1) and =ISNUMBER(B1) in rows 1:100. Suppose your data is in A1:A100 and B1:B100. It does not change text data, and it does not preclude having text data in those cells.) (FYI, changing the format to Number only changes the appearance of data that is already numeric. Note: cant find the Data Analysis button Click here to load the Analysis ToolPak add-in. On the Data tab, in the Analysis group, click Data Analysis. Perhaps what appears to be numeric is actually text, which is not uncommon when you copy-and-paste data, for example. First, enter the bin numbers (upper levels) in the range C4:C8. It says "correlation- input range contains non-numeric data" even I tried putting in NUMBER the format of the table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |