Get whole numbers
Solved
Ouri52
Posted messages
28
Status
Member
-
Khadi -
Khadi -
Hello,
I would like to be able to copy a column containing numbers with decimals and paste them into another column without any decimals in the formula bar. Changing the cell format to zero decimals is not enough.
Thank you.
Configuration: Windows / Chrome 40.0.2214.111
I would like to be able to copy a column containing numbers with decimals and paste them into another column without any decimals in the formula bar. Changing the cell format to zero decimals is not enough.
Thank you.
Configuration: Windows / Chrome 40.0.2214.111
1 answer
-
Hello
it all depends on what value you want
to remove the decimals while keeping the whole number:
for a value in A1, in B1:
=INT(A1)
for the nearest whole number:
=ROUND(A1,0)
in any case:
drag the formula down and do a "special paste" on the column. The formulas will disappear and the values will be retained.
best regards
--
To err is human, to persist is devilish
