Paste number only

suresh_070379 · #1 09-29-2016, 02:20 AM

Hi,
I am using design software Catia.
I am taking the measurement dimension values often from that software and paste it in Excel sheet for further calculations.
Dimensions will be for example ‘500 mm’.
When I paste in Excel, it is pasted along with ‘mm’ in the number formatted cell.
So, Excel shows error message.
If I manually delete that ‘mm’ every time, it is time consuming.
So, I checked the option in Excel for automatically delete that ‘mm’ when I paste the values.
When I checked the internet, there is two options are available.
One is ‘text import wizard’ and another is ‘Data validation’
But, I unable to find a solution.

I need that should be applied for whole sheet.
Kindly give any idea.
Suresh

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to find number of coma and then add that number of rows in word using macro?	PRA007	Word VBA	7	05-27-2015 10:45 PM
How to create a table with a number of line depending a number entered by user	Cellendhyll	Word Tables	3	07-10-2014 05:49 AM
Paste to a series of boxes with one paste?	BudVitoff	Misc	0	11-27-2013 02:51 PM
Paste Special: Copy and Paste Formatting Only?	tinfanide	Word	6	03-06-2013 12:21 AM
Power Point copy-paste number list to RTF editor	himanshu	PowerPoint	0	02-22-2010 12:56 AM