| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste cells copied from another sheet
I have a downloaded report that has dollars in each cell. For some reason,
they downloaded with an apostrophe before each number as '$7.50. How do I copy and paste a column of these numbers and get rid of the ' at the beginning of each number? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To paste copied data in filtered/visible cells only | Excel Discussion (Misc queries) | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| how can I paste all the copied cells | Setting up and Configuration of Excel | |||
| paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
| Preserving lock on cells even when copied and pasted within a sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
