Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste special
Dear Friends
Suppose if I have different values in cell A1:A100 and I want to divide all of them by 10 and get the result rounded to 2 decimal place . how can I do that by using paste special commend regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste special
Hi, Probably best to do this the other way round. First, select your column and format it so that the numbers are rounded to two decimal places: Format Cells Number Number Once this is done, in an empty cell type 10, then copy this. Select your column again and do: Edit Paste Special Divide That should sort it. HTH, SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=560580 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste special
type 10 in a cell select it the copy paste special choose divide and paste over the range a1:a100, then just format the range to 2 d.p Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=560581 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Special and Linking | Excel Discussion (Misc queries) | |||
Paste Special Problem | Excel Discussion (Misc queries) | |||
strange Paste special | Excel Discussion (Misc queries) | |||
paste special - formulas | Excel Worksheet Functions | |||
Paste special treats cells as a picture | Excel Discussion (Misc queries) |