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
rundwald

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
GEWB

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

Regards,
GEWB
My System SpecsSystem Spec
28 Jul 2013   #3
rundwald

Home Premium 64 bit
 
 

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

29 Jul 2013   #4
rundwald

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
Reply

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




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Number of characters in Word text.
Word shows the number of words in the text on the state bar at the bottom. Can it be adjusted to show the number of characters? Thank you very much in advance.
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
Can I set explorer columns for data directory within music library
As an example, The Itunes directory is in My Music. My Music is in a Music library, so the file details in explorer include album, #, etc. Within Itunes is the Apps directory and other data where "album name" doesn't make sense. I want it to display as a non-music directory. There doesn't...
General Discussion
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...
Customization


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 02:58.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App