• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Rounding Function: Decimal place disappears if zero

P

pmreeve

New Member
So we are having an issue with the excel 2010 rounding function. If I want to round a number to 2 decimal places, it works until the number is rounded up and the hundreth place contains a zero. In that situation the round function only displays one decimal place.


For example:

=Round(6.895,2)

Displays 6.9 not 6.90


The round function is nested in a longer formula concatenating text and numbers so just changing the cell format to display two decimal places will not work. Any ideas?
 
Hi Reeve ,


Do you need this intermediate result to be a numeric value ? If you are concatenating this value with some other data , either text or numeric , then can you not use the TEXT function with a format such as "#.00" to get the required two decimal places ?


If you can post the formula where you are using this intermediate result , probably some workaround can be thought of.


Narayan
 
Pmreeve


You probably need to set the Number Format correctly for the cell/s involved


I'd suggest 0.00;-0.00;0.00
 
You must log in or register to reply here.
Back
Top