View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DMC DMC is offline
external usenet poster
 
Posts: 3
Default Can I paste in only absolute value of a measure (no units)?

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?