Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simple Rounding Problem
How can I make the number 27.9864 look like 27.9900? I've tried a few things
and am doiwn to VB stuff which I don't quite understand so any help would be appreciated. |
#2
|
|||
|
|||
Lisa,
If you want to change how a cell is displayed, with the number is in cell A1, the formula =ROUND(A1,2) in another cell, formatted for "0.0000", will show as you desire. If you want to change the number, the macro lines ActiveCell.Value = Application.Round(ActiveCell.Value, 2) ActiveCell.NumberFormat = "0.0000" will change the activecell's actual value. HTH, Bernie MS Excel MVP "Lisa" wrote in message ... How can I make the number 27.9864 look like 27.9900? I've tried a few things and am doiwn to VB stuff which I don't quite understand so any help would be appreciated. |
#3
|
|||
|
|||
In a strict mathematics sense, 27.9864 does not round to 27.9900
The extra zeros are showing a precision that's not there. "Lisa" wrote: How can I make the number 27.9864 look like 27.9900? I've tried a few things and am doiwn to VB stuff which I don't quite understand so any help would be appreciated. |
#4
|
|||
|
|||
Lisa,
You can use the round function for this eg Round(A1, 2) - these will round the value in cell A1 to 2 dps J "Lisa" wrote in message ... How can I make the number 27.9864 look like 27.9900? I've tried a few things and am doiwn to VB stuff which I don't quite understand so any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Problem with date base units for x axis | Charts and Charting in Excel | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) |