Macro for converting text to numbers

Mar 5th, 2002, 02:15 PM

I have an entire column that I need to perform a sumif calculation on. Problem is, when the file was originally exported, it converted all the numbers to text. Can anyone help me with the code that will convert an entire column's entries from text to numbers?

Thanks!

Mark W. · Mar 5th, 2002, 02:34 PM

No code needed. Just select the column of data, choose the Data | Text to Columns... menu command and press [ Finish ].

Mar 5th, 2002, 02:55 PM

I can't seem to get that to work. It tells me that the data is delimited and then i go through a 3 step process. At that point, the text still remains text and not numeric. Is there something else I need to do?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 02:15 PM	#1
Guest Posts: n/a	I have an entire column that I need to perform a sumif calculation on. Problem is, when the file was originally exported, it converted all the numbers to text. Can anyone help me with the code that will convert an entire column's entries from text to numbers? Thanks!

Mar 5th, 2002, 02:34 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	No code needed. Just select the column of data, choose the Data \| Text to Columns... menu command and press [ Finish ].

Mar 5th, 2002, 02:55 PM	#3
Guest Posts: n/a	I can't seem to get that to work. It tells me that the data is delimited and then i go through a 3 step process. At that point, the text still remains text and not numeric. Is there something else I need to do?