Time, of course ... Even if you have the Number format limited to two decimals in Excel, the program remembers a full 15 decimals and will use the fuller number when performing calculations.

copying and pasting it will quickly create a new table with the data in decimal format. Finally, you can copy and paste the new time data over the original. How to Join Two Columns in Excel.

You can choose one or multiple cells at a time ... the number of zeros after the decimal point accordingly before applying the condition. To show 1000 as 1K in Excel, you can use the formatting ...

If a value is less than a million, Excel’s custom format still displays the value with the M for million, but it drops in a decimal point ... it’s time to create the conditional formatting ...