XL 2003: Text to Values

K

Kevin H. Stecyk

Hi,

I just received a spreadsheet from a financial service. It shows a column
of data that ought to be numbers but is instead text. XL 2003 has the
"yellow exclamation point" that allows me to convert from text to number.
Given that I have more than a 100 rows, I would prefer not to do this one at
a time. Is there a feature in XL 2003 that allows me to do this en masse?

If not, no big deal. I can easily create a separate column and use the
required text functions to convert the text to numbers and then copy over
the text. I am just curious if part of XL 2003's new and improved feature
list includes performing text to numbers en masse.

Thank you.

Best regards,
Kevin
 
G

Gord Dibben

Kevin

Copy an empty cell formatted to General.

Select your range of "text numbers" and Paste Special>Add>OK>Esc.

Gord Dibben Excel MVP
 

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

Data, Text to Columns, has commas in the text, plus as a delimeter 2
convert notepad .txt to xp .xl 2
Numbers change in cell even when formatted as text 4
Convert xls to xl? 1
Formatting InputBox or MsgBox 1
Is there a simple way to generate patterns of numbers in XL ? 11
XL 2003: Search & Replace 4
Changing dates to date format 5

Top