I have column with numbers for example 0.5, 1.6 and 2.5 and so on. I want to round them up to 1, 2, 3 integer instead of double. Is there a macro that does that? I have this code but still I am getting double after I run this code.

Thanks

    Columns("F").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.NumberFormat = "0"