Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding problem
hello,
I copied and pasted some data from a web page into an excel ss. 1 column as fractions like: 0.10 0.10 0.20 0.10 0.20 I can't add up the column. I have them formatted as numbers, but excel doesn't recognize them as such. All attempts to add from this column equals 0. Any ideas? thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding problem
Select any blank cell, right clickselect Copyhighlight your data range
right clickPaste specialselect AddOK "Japhy" wrote: hello, I copied and pasted some data from a web page into an excel ss. 1 column as fractions like: 0.10 0.10 0.20 0.10 0.20 I can't add up the column. I have them formatted as numbers, but excel doesn't recognize them as such. All attempts to add from this column equals 0. Any ideas? thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding problem
In om, Japhy
spake thusly: I copied and pasted some data from a web page into an excel ss. 1 column as fractions like: 0.10 0.10 0.20 0.10 0.20 I can't add up the column. I have them formatted as numbers, but excel doesn't recognize them as such. My guess is, what you copied has whitespace before or after the numbers. The whitespace (space or tab chars) turns the cell content into a string instead of a number. You can try using the TRIM, sUBSTITUTE, or CLEAN function (then copy-and-paste the result as Special - Values). -dman- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
strange problem with links updates in excel | Excel Discussion (Misc queries) | |||
Adding or combining time problem. | Excel Worksheet Functions | |||
problem adding | Excel Discussion (Misc queries) | |||
Adding summaries, rows and pre-population | New Users to Excel | |||
problem with adding columns of numbers | Excel Worksheet Functions |