How can I Round a large amount of #s w/o typing round formula in each cell

Ex: 39.548759631 to 40

You could use the decrease decimal button on the formatting tool bar.

or format cells as Number with no decimal points.

However this is only a visual solution. Best to add another column and
enter =ROUND(A1,0) then paste special results

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=567147

Highlight the cells, then right-click FormatCells NumberTab Number
select zero decimal places ok

Vaya con Dios,
Chuck, CABGx3



"Mike W" wrote:

How can I Round a large amount of #s w/o typing round formula in each cell

Ex: 39.548759631 to 40

Actually what I am looking for is for the detail of the cell to be rounded as
well. For example:

a1 = 12.356487

Visually it shows 12

I want to be able to have the detail of the cell equal to 12. So that when
I am using this cell in a calculation it views it as a whole number. The
only way I kow of is to retype the number as 12 or use the round function but
I am dealing with 100's of cells. Thanks.

"CLR" wrote:

Highlight the cells, then right-click FormatCells NumberTab Number
select zero decimal places ok

Vaya con Dios,
Chuck, CABGx3



"Mike W" wrote:

How can I Round a large amount of #s w/o typing round formula in each cell

Ex: 39.548759631 to 40

Try this:

<Tools <Options <Calculations tab,
And *check* "Precision As Displayed".

Check first to make sure that this doesn't hurt any other calculations in
the rest of the WB.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike W" wrote in message
...
Actually what I am looking for is for the detail of the cell to be rounded
as
well. For example:

a1 = 12.356487

Visually it shows 12

I want to be able to have the detail of the cell equal to 12. So that
when
I am using this cell in a calculation it views it as a whole number. The
only way I kow of is to retype the number as 12 or use the round function
but
I am dealing with 100's of cells. Thanks.

"CLR" wrote:

Highlight the cells, then right-click FormatCells NumberTab Number

select zero decimal places ok

Vaya con Dios,
Chuck, CABGx3



"Mike W" wrote:

How can I Round a large amount of #s w/o typing round formula in each
cell

Ex: 39.548759631 to 40

You could use the menu item Tools|Options|Calculation and check €œPrecision as
displayed€�. Note that this will impact all calculations, not just the
particular ones that you intend; consequently it may have undesirable side
effects.

Jerry

"Mike W" wrote:

Actually what I am looking for is for the detail of the cell to be rounded as
well. For example:

a1 = 12.356487

Visually it shows 12

I want to be able to have the detail of the cell equal to 12. So that when
I am using this cell in a calculation it views it as a whole number. The
only way I kow of is to retype the number as 12 or use the round function but
I am dealing with 100's of cells. Thanks.

"CLR" wrote:

Highlight the cells, then right-click FormatCells NumberTab Number
select zero decimal places ok

Vaya con Dios,
Chuck, CABGx3



"Mike W" wrote:

How can I Round a large amount of #s w/o typing round formula in each cell

Ex: 39.548759631 to 40

Hi Mike......
This is kinda crude, but perhaps it's what you're looking for..........

Sub RoundMe()
Dim lastrow As Long, r As Long
Dim num1 As String
lastrow = Cells(Rows.Count, "A").End(xlUp).Row
For r = lastrow To 1 Step -1
If Cells(r, "A") 0 Then
Cells(r, "A").Select
num1 = Selection.Value
End If
With ActiveCell
.Value = "=round(" & num1 & ",0)"
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
End With
Next r
End Sub

Vaya con Dios,
Chuck, CABGx3





"Mike W" wrote:

Actually what I am looking for is for the detail of the cell to be rounded as
well. For example:

a1 = 12.356487

Visually it shows 12

I want to be able to have the detail of the cell equal to 12. So that when
I am using this cell in a calculation it views it as a whole number. The
only way I kow of is to retype the number as 12 or use the round function but
I am dealing with 100's of cells. Thanks.

"CLR" wrote:

Highlight the cells, then right-click FormatCells NumberTab Number
select zero decimal places ok

Vaya con Dios,
Chuck, CABGx3



"Mike W" wrote:

How can I Round a large amount of #s w/o typing round formula in each cell

Ex: 39.548759631 to 40