Solved Number data in 10 columns and 25 rows pasted from other source is text

[rundwald]

..... and I want to convert the lot to 2 decimal place numbers.

Excel has several methods, but none seem to work for conversion in bulk. Working on futher cells from a suitably formatted one does not work.

Is the only way to solve my problem to manually enter the numbers elsewhere, clear the original cells, and then cut and paste back to the original cells?

Help please!

 

[GEWB]

Need more info about the source text file. When opened in Word and Show All (the paragraph mark) is enabled, what does the text file look like?

See this thread from a couple years ago and see if it gives you any ideas:

http://www.sevenforums.com/microsof...p-data-text-file-arranged-excel-specific.html

Regards,
GEWB

 

[rundwald]

I'll have to read the link later, but thanks.

Data was acquired from numbeo.com for several currencies as here. only cols 1&2 being relevant. The intention was to convert to GBP.

 

[rundwald]

Hi Guys! I've found a way to do it.

I re-saved the Excel file as a PDF, selected the data I wanted to convert from text to numbers and copied it to thr clipboard. Then in the Excel sheet I pasted the clipboard contents over the problem text. ISNUMBER function proved all items are now numbers.