Paste number only

[suresh_070379]

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