convert text to numbers

G

Gary B

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

Bernard Liengme

This trick sometimes works
Click an empty cell and use Copy
Select the problem values and use Edit | Paste Special with Add specified
Performing a mathematical operation (adding zero) can sometimes cohere the
text back to numbers
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Greater Than Symbols and calculations 0
Numbers showing Up Centered in Cell ? 1
Convert numbers stored as text to numbers 2
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Adding numbers and text 6
To convert calculated numbers for Cut & Paste 2
Changing Text To Numbers ? 1
convert web copied text to numbers 3

Top