View original (French)

[Excel] - Removing Unnecessary Decimals

Solved
Fred.21 Posted messages 2 Status Membre -  
Philgood.001 Posted messages 8 Status Membre -
Hello,
kudos to the participants of this forum who help users in difficulty.

Having not found any topics regarding the 2 points that are troubling me, it's my turn to ask for your help:

1/ In a table where the cells contain formulas of the type =$A4/$C$3, I would like to remove the ",00" after the whole numbers to have 1 or 17 instead of 1,00 or 17,00 while keeping 12,56 for 12,5621 etc. The resulting data is in Number format with 2 decimal places, but if it's possible to reduce the number of decimal places from Standard format to 2, why not...

2/ In two other versions of this table, I will need to round these results down to the nearest whole number for the first (3.87 = 3), and to the nearest whole number for the second (3.87 = 4 | 3.48 = 3).

How can I achieve all of this in Excel 2007?

Thank you in advance for your response and your time.
Configuration: Windows 7 / Firefox 3.0.7 / Excel 2007

3 réponses

Réponse 1 / 3
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
Good evening,

1) revert to 'standard' format and in formula: =round(your_formula;2)

2a) =int(your_formula)

2b) =round(your_formula;0)

eric
9
foufou
 
Perfect, exactly what I needed to get the value 233 instead of 233.3564324342.
Thank you
0
Philgood.001 Posted messages 8 Status Membre
 
Hello,
I know, it's been 8 years since the answer was given, but honestly thank you, after browsing through several forums on the issue, this is the only perfect answer without compromise
(Q°/A° 1)).
Even better than the solution ##,## which keeps the comma permanently.
Excellent!!!
And thanks again!!!
0