formatting cells with floating point numbers

    how do we ensure that floating point numbers in cells dont get truncated or rounded off. For example if cell A1has 5.69, Excel automatically changes it to 5.7. How do we stop Excel from doing this and retain a1 as 5.69 only

    Format the cells as numbers with two decimals:


    Select the cells or entire column.
    Format-Cells.
    Choose the Number tab.
    Choose Number from the left-hand column and on the right, choose 2 decimals, and a separate (comma) if you want it.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login