Solved

# Round a number

Posted on 2011-03-03
189 Views
Please tell me how I can display the rounded version of a number (without using a function).
THe number is the cell must display the rounded version, but the actual value must still be the non-rounded version.
0
Question by:dshrenik
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 3
• 3

LVL 24

Expert Comment

ID: 35029682
Just set the cell format to Number with 0 Decimal places.
0

Author Comment

ID: 35029701
If possible, can you give me the procedure to do the same. Thanks!
0

LVL 39

Accepted Solution

nutsch earned 250 total points
ID: 35029745
Look at the screencast below. You get to the cells format box by clicking Ctrl+1

Thomas
nutsch-416086.flv
0

LVL 24

Assisted Solution

jimyX earned 250 total points
ID: 35029772
Range("yourcell").NumberFormat = "0"
0

Author Comment

ID: 35029808
Thats not rounding the number. IT is just trimming it right?
0

LVL 24

Expert Comment

ID: 35029841
No, it's rounding the number for viewing but the original number is kept intact. try it please.
0

Author Comment

ID: 35029853
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to usâ€¦
###### Suggested Courses
Course of the Month3 days, 2 hours left to enroll