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

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

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

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

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



Similar help and support threads for2: Number data in 10 columns and 25 rows pasted from other source is text
Thread Forum
Solved Web site data to excel columns Browsers & Mail
Subfolders are not pasted. only parent folder is pasted General Discussion
Solved Re: EXCEL- resorting rows so they each relate to original rows Microsoft Office
Changing fonts of pasted Japanese text (hiragana/kanji/etc) General Discussion
Can I set explorer columns for data directory within music library General Discussion
Number of rows showing on the "thumbnail wall" Media Center
Toolbars - Number of rows - How to control? 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 12:24 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33