View original (French)

[Excel] - Removing Unnecessary Decimals

Solved
Fred.21 Posted messages 2 Status Member -  
Philgood.001 Posted messages 8 Status Member -
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 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor 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
    1. foufou
       
      Perfect, exactly what I needed to get the value 233 instead of 233.3564324342.
      Thank you
      0
    2. Philgood.001 Posted messages 8 Status Member
       
      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