Am new user and need assistance. How do I format a specific cell(s) to
roundup using Excel 2000?

Thank you

You can roundup a cell value in another cell, but you cannot format the cell
to roundup.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul" wrote in message
...
Am new user and need assistance. How do I format a specific cell(s) to
roundup using Excel 2000?

Thank you

Semantics Bob.<bg

True, you cannot *format* a cell to roundup, but you can *formulate* the
cell to roundup, *without* needing an additional cell.

Need some specific examples in order to offer any suggestions.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Bob Phillips" wrote in message
...
You can roundup a cell value in another cell, but you cannot format the cell
to roundup.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul" wrote in message
...
Am new user and need assistance. How do I format a specific cell(s) to
roundup using Excel 2000?

Thank you

You can't format a cell to round up, but you can use an event macro:

Put this in your worksheet code module (right-click the worksheet tab
and choose View Code):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim rTargets As Range
Dim rCell As Range
Set rTargets = Intersect(Target, Range("A1:A10,B2,J10"))
If Not rTargets Is Nothing Then
For Each rCell In rTargets
With rCell
If IsNumeric(.Value) Then
Application.EnableEvents = False
.Value = Application.RoundUp(.Value, 0)
Application.EnableEvents = True
End If
End With
Next rCell
End If
End Sub


Change the Range("A1,B2,J10") to suit.

In article ,
"Paul" wrote:

Am new user and need assistance. How do I format a specific cell(s) to
roundup using Excel 2000?

Thank you

Do you literally mean round 'UP' (9.2 10), or just round to the nearest
decimal place (9.2 9, 9.6 10)



"Paul" wrote in message
...
Am new user and need assistance. How do I format a specific cell(s) to
roundup using Excel 2000?

Thank you

If I may jump in here if it isn't to late and this thread isn't looked
at any more.

I too need to round up a cell formula.

In a cell I have =D5/100. I need the result to always round up,
example 9.2 would be 10.

Thanks

Jess

On Sat, 20 Aug 2005 03:50:01 -0700, "Paul"
wrote:

Am new user and need assistance. How do I format a specific cell(s) to
roundup using Excel 2000?

Thank you

Hi Jess

Try
=ROUNDUP(D5/100,0)

Regards

Roger Govier


Jess wrote:
If I may jump in here if it isn't to late and this thread isn't looked
at any more.

I too need to round up a cell formula.

In a cell I have =D5/100. I need the result to always round up,
example 9.2 would be 10.

Thanks

Jess

On Sat, 20 Aug 2005 03:50:01 -0700, "Paul"
wrote:


Am new user and need assistance. How do I format a specific cell(s) to
roundup using Excel 2000?

Thank you

Thanks! I hit all around it, how simple!


On Wed, 21 Sep 2005 19:10:48 +0100, Roger Govier
wrote:

Hi Jess

Try
=ROUNDUP(D5/100,0)

Regards

Roger Govier


Jess wrote:
If I may jump in here if it isn't to late and this thread isn't looked
at any more.

I too need to round up a cell formula.

In a cell I have =D5/100. I need the result to always round up,
example 9.2 would be 10.

Thanks

Jess

On Sat, 20 Aug 2005 03:50:01 -0700, "Paul"
wrote:


Am new user and need assistance. How do I format a specific cell(s) to
roundup using Excel 2000?

Thank you