View original (French)

Excel: numbers after decimal point

Solved
bjour Posted messages 8544 Registration date   Status Contributeur 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 réponses

Réponse 1 / 3
georges86400 Posted messages 1893 Status Membre 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
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
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
Réponse 2 / 3
funbreizhou Posted messages 89 Status Membre 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
Réponse 3 / 3
bjour Posted messages 8544 Registration date   Status Contributeur 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