Roundup with paste special
 

I'd like to roundup the results to a paste special operation. I'm multiplying
100's of cells by, e.g. 0.7458, and this obviously results in an unrounded
number. I then have to manually amend all the cells to round the results.
I'm wondering is there is a means to "past special & roundup" simultaneously?
I use Excel 2003.
Al

Roundup with paste special
 

If the cells are formatted as you wish to see them (eg as Number with
2 dp), you can use Tools | Options | Calculation tab and then check
Precision as Displayed - when you click OK XL will give you a warning,
as this could affect other values in your workbook. Once it has done,
you can go back and un-check that option, so that future use will not
be affected.

Hope this helps.

Pete

On Jun 30, 12:52*pm, Al wrote:
I'd like to roundup the results to a paste special operation. I'm multiplying
100's of cells by, e.g. 0.7458, and this obviously results in an unrounded
number. I then have to manually amend all the cells to round the results.
I'm wondering is there is a means to "past special & roundup" simultaneously?
I use Excel 2003.
Al

Roundup with paste special
 

Have just re-read your title - the technique I described gives you
rounded numbers, not necessarily rounded UP.

Pete

On Jun 30, 1:07*pm, Pete_UK wrote:
If the cells are formatted as you wish to see them (eg as Number with
2 dp), you can use Tools | Options | Calculation tab and then check
Precision as Displayed - when you click OK XL will give you a warning,
as this could affect other values in your workbook. Once it has done,
you can go back and un-check that option, so that future use will not
be affected.

Hope this helps.

Pete

On Jun 30, 12:52*pm, Al wrote:



I'd like to roundup the results to a paste special operation. I'm multiplying
100's of cells by, e.g. 0.7458, and this obviously results in an unrounded
number. I then have to manually amend all the cells to round the results..
I'm wondering is there is a means to "past special & roundup" simultaneously?
I use Excel 2003.
Al- Hide quoted text -

- Show quoted text -

Roundup with paste special
 

Hi

If you can work with a VB solution, the following will carry out the task
for any range of cells that you select.

Sub RoundupValues()
Dim mult As Double, c As Range
mult = InputBox("enter Multiplier")
For Each c In Selection
c.Value = WorksheetFunction.RoundUp(c * mult, 0)
Next
End Sub


Copy the code above
Alt+F11 to invoke the VB Editor
InsertModule
Paste Code into white pane that appears.
Alt+F11 to return to Excel

To use
Select the range of cells you want to Multiply
Alt+F8 to bring up the Macro dialogue
Select RoundupValuesRun
You will be prompted to input the Multiplier 0.7458 (or any other)
OK


--
Regards
Roger Govier

"Al" wrote in message
...
I'd like to roundup the results to a paste special operation. I'm
multiplying
100's of cells by, e.g. 0.7458, and this obviously results in an unrounded
number. I then have to manually amend all the cells to round the results.
I'm wondering is there is a means to "past special & roundup"
simultaneously?
I use Excel 2003.
Al