| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| absolute paste link | Excel Discussion (Misc queries) | |||
| Paste Linking with Absolute Reference | Excel Discussion (Misc queries) | |||
| Excel 2003 ~ How to change the default units of measure? | Setting up and Configuration of Excel | |||
| Excel 2003 ~ How to change the default units of measure? | Excel Discussion (Misc queries) | |||
| cut & paste with short cut keys (ctrl C V) with absolute cell refe | Excel Discussion (Misc queries) | |||
Threaded Mode
