View original (French)

Excel: numbers after decimal point

Solved
bjour Posted messages 8544 Registration date   Status Contributor Last intervention   -  
 Fgaye -
Hello,

I need to create an Excel table that calculates formulas, percentages... no problem.
However, I pay attention to significant figures, and I would like to know what "phrase" to enter in my cell so that there are only two digits after the decimal point.

Thank you even for a starting answer!!

3 answers

  1.
    georges86400 Posted messages 1893 Status Member 143
     
    Hello
    you select your columns, then go to Format, click, and in the window that opens, you click on Number and there you indicate the number of digits after the decimal point and then you click OK!
    And all your cells will display only 2 decimals.
    19
    1. souad beg
       
      salam
      but this does not completely solve the problem, it is better to choose the formula: =+ROUND ex +ROUND(A1,2) if it is 2 digits after the decimal point
      1
    2. Fgaye
       
      Despite the fact that I set 2 decimal places in a cell and for the result of the "quotient" function, it only retains the integer part of the division result. However, I need two precise decimals, other than ,00. I'm looking for ... and it's driving me crazy. Did the designer of Excel provide a SIMPLE solution to this problem? Thank you in advance to anyone who can help!
      0
  2. funbreizhou Posted messages 89 Status Member 11
     
    Hello,
    in VBA it would look like this:

    Sub significant_figures()

    Columns("A:A").Select
    Selection.NumberFormat = "0.00"

    End Sub

    All the numbers in the cells of column A will have 2 decimal places.
    2
  3. bjour Posted messages 8544 Registration date   Status Contributor Last intervention   4 079
     
    Thank you for your response, but in the meantime, I continued to search, and actually, if you right-click on the cell, then choose "Format Cells," you can then select what you want: decimal, integer, number of decimals, scientific notation, currency symbols, etc....

    Thank you anyway!!
    1