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?
|