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

rundwald

New member
Member
VIP
Local time
2:21 PM
Messages
394
Location
UK, Hampshire
..... 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!:cry:
 

My Computer My Computer

At a glance

Home Premium 64 bit2.9 gigahertz Intel Core2 Duo 64 kilobyte pri...4096 Megabytes Usable Installed Memory Slot '...ATI Radeon HD 4300/4500 Series
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Dell Inspiron 560MT
OS
Home Premium 64 bit
CPU
2.9 gigahertz Intel Core2 Duo 64 kilobyte primary memory cac
Motherboard
Board: Dell Inc. 0K83V0 A00 Serial Number: ..CN750939CP069B
Memory
4096 Megabytes Usable Installed Memory Slot 'DIMM0' has 102
Graphics Card(s)
ATI Radeon HD 4300/4500 Series
Sound Card
High Definition Audio Device NVIDIA High Definition Audio (
Monitor(s) Displays
DELL ST2210 [Monitor] (21.7"vis, s/n P479R01Q0VCU, January 2
Screen Resolution
1920x1080
Hard Drives
628.58 Gigabytes Usable Hard Drive Capacity
554.78 Gigabytes Hard Drive Free Space
Keyboard
Std Dell UK
Mouse
KEYBOARD, 105, UNITED KINGDOM, KWE9C0
Internet Speed
~8000 kbps
Antivirus
Avast Free
Browser
Chrome
Other Info
Office 2007: Photo Editing; Serif PhotoPlus X7

My Computer My Computer

At a glance

Linux Mint / XP / Win7 Home, Pro, Ultimate / ...
Computer type
PC/Desktop
Computer Manufacturer/Model Number
(7 different computers booting up to 10 systems)
OS
Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
Other Info
Four desktops, two laptops, one notebook and one tablet
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 Computer My Computer

At a glance

Home Premium 64 bit2.9 gigahertz Intel Core2 Duo 64 kilobyte pri...4096 Megabytes Usable Installed Memory Slot '...ATI Radeon HD 4300/4500 Series
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Dell Inspiron 560MT
OS
Home Premium 64 bit
CPU
2.9 gigahertz Intel Core2 Duo 64 kilobyte primary memory cac
Motherboard
Board: Dell Inc. 0K83V0 A00 Serial Number: ..CN750939CP069B
Memory
4096 Megabytes Usable Installed Memory Slot 'DIMM0' has 102
Graphics Card(s)
ATI Radeon HD 4300/4500 Series
Sound Card
High Definition Audio Device NVIDIA High Definition Audio (
Monitor(s) Displays
DELL ST2210 [Monitor] (21.7"vis, s/n P479R01Q0VCU, January 2
Screen Resolution
1920x1080
Hard Drives
628.58 Gigabytes Usable Hard Drive Capacity
554.78 Gigabytes Hard Drive Free Space
Keyboard
Std Dell UK
Mouse
KEYBOARD, 105, UNITED KINGDOM, KWE9C0
Internet Speed
~8000 kbps
Antivirus
Avast Free
Browser
Chrome
Other Info
Office 2007: Photo Editing; Serif PhotoPlus X7
Hi Guys!:D 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 Computer My Computer

At a glance

Home Premium 64 bit2.9 gigahertz Intel Core2 Duo 64 kilobyte pri...4096 Megabytes Usable Installed Memory Slot '...ATI Radeon HD 4300/4500 Series
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Dell Inspiron 560MT
OS
Home Premium 64 bit
CPU
2.9 gigahertz Intel Core2 Duo 64 kilobyte primary memory cac
Motherboard
Board: Dell Inc. 0K83V0 A00 Serial Number: ..CN750939CP069B
Memory
4096 Megabytes Usable Installed Memory Slot 'DIMM0' has 102
Graphics Card(s)
ATI Radeon HD 4300/4500 Series
Sound Card
High Definition Audio Device NVIDIA High Definition Audio (
Monitor(s) Displays
DELL ST2210 [Monitor] (21.7"vis, s/n P479R01Q0VCU, January 2
Screen Resolution
1920x1080
Hard Drives
628.58 Gigabytes Usable Hard Drive Capacity
554.78 Gigabytes Hard Drive Free Space
Keyboard
Std Dell UK
Mouse
KEYBOARD, 105, UNITED KINGDOM, KWE9C0
Internet Speed
~8000 kbps
Antivirus
Avast Free
Browser
Chrome
Other Info
Office 2007: Photo Editing; Serif PhotoPlus X7
Back
Top