convert text to number

G

Gary

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

Ken Wright

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

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

Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Finding the proper style field and the numbered paragraph value within the style 0
Date Formats 4
Finding the right style field in VBA 0
WORD VBA Search and switch to advanced ... 1
Number stored as text 4
Page numbering with Merged Document and IF statements 1

Top