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 :-)
------------------------------­------------------------------­----------------
 
Back
Top