Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Number data in 10 columns and 25 rows pasted from other source is text

28 Jul 2013   #1

Home Premium 64 bit
Number data in 10 columns and 25 rows pasted from other source is text

..... 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!

My System SpecsSystem Spec
28 Jul 2013   #2

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM

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:

Please Help - Data in Text File to be arranged in Excel in a specific

My System SpecsSystem Spec
28 Jul 2013   #3

Home Premium 64 bit

I'll have to read the link later, but thanks.
Data was acquired from for several currencies as here. only cols 1&2 being relevant. The intention was to convert to GBP.
My System SpecsSystem Spec

29 Jul 2013   #4

Home Premium 64 bit

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.
My System SpecsSystem Spec

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

Thread Tools

Similar help and support threads
Thread Forum
How to format table for text but also add columns
Word 2003 Trying to set up a two column the left main column is the right small column are $ amounts corresponding to the right text column. I can not figure out how to get the right column to line up evenly with the left...seems to be a double space in the right column...
Microsoft Office
Web site data to excel columns
Is it possible to fetch some lines of data from a group of web pages and paste in to Excel?Pls view the image for required excel columns. urls are, Stock Share Price dlf ltd | Get Quote dlf | BSE Stock Share Price dlf ltd | Get Quote dlf | BSE Stock Share Price jaiprakash associates ltd | Get...
Browsers & Mail
Re: EXCEL- resorting rows so they each relate to original rows
Hi, I couldn't find an answer in the Forums for this in the past half hour of looking through them- there are so many, and I need an answer sooner than in the 4 or 5 days it will take me to get through them in HOPES of finding my answer. Sorry. So could someone who knows Excel in Windows 7...
Microsoft Office
Number of rows showing on the "thumbnail wall"
My boss has a new touchscreen computer with Windows 7 and Media Center. Photos are loaded. He wants to be able to have one LONG row of photos that he can scroll back and forth horizontally by flicking his finger on the screen (like his phone). If there are six pictures in a folder, I get...
Media Center
Toolbars - Number of rows - How to control?
I make my taskbar two rows high, and I made a toolbar named "Progs" containing several folders that contain program shortcuts. The toolbar is making poor use of the vertical space available to it, using only two rows of folders, with the bottom third of it going completely unused. The 2nd row of...

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 23:55.
Twitter Facebook Google+