convert text to number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel 2003 SP2 and the prescribed methods in converting test to numbers
do not work. i.e.Copy value and Edit/ Paste Special/ Operation
(Add/Multiply) does not work. Is there a problem with this version?
 
Nope, more likely to be your data. Try running Dave McRitchies Trimall
macro against your data to clean it up, format it as numeric and then try
the methods you list.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
You must log in or register to reply here.

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

How to Convert EML to PST in 2025? 2
Convert Text To Number 3
Number stored as text 4
Converting text to numbers, but not blank cells 2
Excel Convert word into numbers and back 4
custom function to convert numbers stored as text 4
Windows XP text to number formatting with negatives 2
My cut and paste to my web site, converts to text and not visual 3

Back
Top