Tag Archive: Format number

Articles sur le thème : Format number

How to round in k$ without formula?

Write your numbers in K$ In Excel, you can easily display your numbers in kilo dollars K$ or million dollars (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. The last one is my favorite …

Continue reading

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

Time Formats in Excel

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

Continue reading

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

Displaying Negative Numbers in Parentheses – Excel

Negatives numbers are written with parenthesis in red

With Excel, you can display your negative numbers inside a parenthesis.
To do that, you have to create a customize code like it is explain in this article.

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

Round to the Nearest Ten, Hundred, Multiple..

With Excel, it’s very easy to round to the nearest ten, hundred, thousand, …. Standard use of the ROUND function The ROUND function is a very common Excel function. You use it when you want to round a number. =ROUND(number, decimal) “Number” is your number “Decimal” is the number of decimal places you want to keep …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/round-to-the-nearest-tenth-hundredth/