Welcome Guest.


How to remove the decimals after the number in the Excel becomes an integer

Asked by: Brian 312 views IT March 13, 2019

Not rounding off with a formula    Copying with a formula and copying   Selectively pasting into a cell or having a decimal  It is necessary not to have a decimal directly after the integer

2 Answers

  1. +6Votes  

    What is the formula?

    =INT(original formula)

    Copy and paste as a value


    Paul Wood- March 13, 2019 |

  2. +6Votes  

    Your “Paste” option is wrong , it causes problems.

    Catherine Roberts- March 13, 2019 |