convert text to numbers
Have copied and pasted a column of numbers to an excel 2003 worksheet. When I
try to sum then I get a zero as the sum. Have tried to use the =Value(A1) formula to read to the next col as a number but get the #VALUE! Error. Must be an easy way to do this, any ideas? |
convert text to numbers
You may have some nonprintable characters try Value(Clean(A1))
-- If this helps, please remember to click yes. "Gary B" wrote: Have copied and pasted a column of numbers to an excel 2003 worksheet. When I try to sum then I get a zero as the sum. Have tried to use the =Value(A1) formula to read to the next col as a number but get the #VALUE! Error. Must be an easy way to do this, any ideas? |
convert text to numbers
Hi Gary,
maybe you have blank spaces that you cannot see enter in another column =trim(A1) then do copy of this column, go to A1 and paste special, values "Gary B" wrote: Have copied and pasted a column of numbers to an excel 2003 worksheet. When I try to sum then I get a zero as the sum. Have tried to use the =Value(A1) formula to read to the next col as a number but get the #VALUE! Error. Must be an easy way to do this, any ideas? |
All times are GMT +1. The time now is 07:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com