Tag Archive: Format number

Articles sur le thème : Format number

How to round in k$ without formula?

Introduction of the article In Excel, you can easily transform your number kilo euros k$(or dollar) or million euros(m$) with 3 methods.  In this article you will find 3 techniques to display a result in k$ (or m$ for the millions]. Each technique have their own benefits and disadvantages. Honestly, the last one is the greatest. Paste Special …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/how-to-round-in-k-without-formula/

Time format in Excel

In Excel, working with the time is not difficult but you need to know few rules to avoid big mistakes. In this article you will see these rules and how to manage the time format. Difference between date and time in Excel In Excel, hours are always a fraction of a day. So it’s decimal …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/time-format-in-excel/

Negative numbers with parenthesis – Excel

Negative numbers in Excel In Excel, the basic way to format negative numbers is to use the Accounting number format. This option will display your negative number in red.   But, for some reports, negative numbers must be displayed with parenthesis. Let’s see how to do that Customize your number To display your negative numbers …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/negative-numbers-with-parenthesis-excel/