I cannot think of a Paste trick to do this (would be nice).

Is it always a SINGLE letter on the right?
then use a helper column with =--MID(A1,1,LEN(A1)-1); do a copy followed by
paste special - values. Now the helper column can replace the original
column.
The double negation converts text to number

If there are a limited number of units (say H, KM or DAYS):
=--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"h",""),"km"," "),"days","")

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"DMC" wrote in message
...
I am trying paste in a large series of values that have a unit of measure
designator attached, therfore, is pasting in a text, rathe than a number.
Example: 120h, where I would like to paste in only 120. Is ther way to
convert text to number, or drop the "h" when pasting?