Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Data not recognized by Formulas
I have a simple setup of data that originated from a .csv file. I copied,
pasted values into a specific set of cells, yet the sum formula isn't picking up on the numbers. The formula DOES pick up on the number when I double click each each individual cell with data in it. I've pulled all formats, trimmed, and am looking at the numbers, yet they are not totalling at the end of the row unless I go through each one and double click? Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Data not recognized by Formulas
They were imported as text rather than numbers:
1. in an un-used cell enter 1 2. copy this cell 3. Paste/special/multiply onto the cells you want to convert from Text to Number -- Gary''s Student - gsnu200768 "jasonr17" wrote: I have a simple setup of data that originated from a .csv file. I copied, pasted values into a specific set of cells, yet the sum formula isn't picking up on the numbers. The formula DOES pick up on the number when I double click each each individual cell with data in it. I've pulled all formats, trimmed, and am looking at the numbers, yet they are not totalling at the end of the row unless I go through each one and double click? Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Data not recognized by Formulas
I get the method... but it didn't work. Still, the only way the SUM formula
to recognize the cells under its umbrella, is for me to double click them. (I have tools/options/zero values set to NOT Show zeroes. Zero's currently show until I double click the cell, then they dissapear) ??? "Gary''s Student" wrote: They were imported as text rather than numbers: 1. in an un-used cell enter 1 2. copy this cell 3. Paste/special/multiply onto the cells you want to convert from Text to Number -- Gary''s Student - gsnu200768 "jasonr17" wrote: I have a simple setup of data that originated from a .csv file. I copied, pasted values into a specific set of cells, yet the sum formula isn't picking up on the numbers. The formula DOES pick up on the number when I double click each each individual cell with data in it. I've pulled all formats, trimmed, and am looking at the numbers, yet they are not totalling at the end of the row unless I go through each one and double click? Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Data not recognized by Formulas
What does "did not work" mean? Did it not convert the text to numbers? Or
some other problem? The first thing you must do is ensure you have numbers, not text. You can go no further in looking for a solution until you are sure all your data is numbers. What happens when you check the cells with =isnumber(range). If this returns True on all your cells, and you still have problems, then post back. Regards, Fred. "jasonr17" wrote in message ... I get the method... but it didn't work. Still, the only way the SUM formula to recognize the cells under its umbrella, is for me to double click them. (I have tools/options/zero values set to NOT Show zeroes. Zero's currently show until I double click the cell, then they dissapear) ??? "Gary''s Student" wrote: They were imported as text rather than numbers: 1. in an un-used cell enter 1 2. copy this cell 3. Paste/special/multiply onto the cells you want to convert from Text to Number -- Gary''s Student - gsnu200768 "jasonr17" wrote: I have a simple setup of data that originated from a .csv file. I copied, pasted values into a specific set of cells, yet the sum formula isn't picking up on the numbers. The formula DOES pick up on the number when I double click each each individual cell with data in it. I've pulled all formats, trimmed, and am looking at the numbers, yet they are not totalling at the end of the row unless I go through each one and double click? Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date not recognized | Excel Discussion (Misc queries) | |||
Cell value not recognized by code. | Excel Discussion (Misc queries) | |||
changing formulas to values so that they will be recognized by Find and Replace | Excel Discussion (Misc queries) | |||
Command not recognized | Excel Worksheet Functions | |||
Data isn't being recognized. | Excel Worksheet Functions |