| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Stop rounding values
I have several values that have been set to show only 2 decimal places,
but the actual value has more. When I sum the two cells I get the wrong result. For example A1 = 23.34656 displayed as 23.35 A2 = 1.1072 displayed as 1.11 When the two displayed values are added the answer is 24.46 but if you enter the formula A1+A2 the result is 24.45 How do I stop Excel doing this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Can I stop rounding in excel? | Excel Discussion (Misc queries) | |||
| Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) | |||
| How do I stop excel replacing numerical values with the date? | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Threaded Mode
