Problem with decimal places in excel 2000?
I have a spreadsheet in which I have done some calculations (Added tax - prob not relevent) and ended up with a figure with more than 2 decimal places eg. 4.5145
I want this figure to be in the actual spreadsheet with 2 decimal places so I can do a VLOOKUP on it. At the moment the VLOOKUP is coming back as NA as the table has 4.51 in it not 4.5145.
It appears when you look at the overall sheet to be to 2 dec places, however when you actually click on the cell it shows as 4.5145 after the = sign at the top.
I have tried, format, cells, number with 2 dec places, and also tools, options, edit, fixed decimal. I have also tried copy, and paste values. All still leave me with the long number by the = when clicked on.
Update:Cheers Jeff, thats sussed it!!
More Questions From This User See All
![BHH [Bustin' Ho's Heads]](https://q2a.es/img/profile/B/BHHyyBustinyyx27yyHoyyx27ysyHeadsy.jpg)
Answers & Comments
Verified answer
When you do the calculation, include it within the "Round" function.
For example, in the formula for the cell you are describing, instead of "= A1+A2" or whatever, use =Round(A1+A2,2).
The ",2" tells it to round the result to 2 decimal places.
The methods you have used only cause the display of the number to change, not the actual number itself.
Bert
you can use the =round() function like this
=round(a1,2) will display the cell that is in a1 with only 2 decimal places.
Try using =Fixed() or =Round() formulas on the results cells.
Did you try the "Round" function? ROUND(formula, number of digits)
For example, if your formula is "=A1-A2" which results in 4.5145 try "=ROUND(A1-A2,2)"