Tag Archive: Format number

Articles sur le thème : Format number

How to round in k$ without formula?

How to round in k$ without formula

With Excel, you can round easily your data in k$ or m$ without creating a single formula. What you have to do is to create a custom format number

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

Time Formats in Excel

Standard time format in Excel

This article presents all the subtleties of the time format and the mistakes to avoid in Excel

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..

Round to the nearest hundredth

You can easily round your number to the nearest tenth, hundredth or thousandth with the function ROUND

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

Dash for 0 in Excel

The Dash for 0

Learn how you can display your zeros as a dash in your spreadsheets.

Permanent link to this article: https://www.excel-exercise.com/dash-for-0-in-excel/