I made several columns with numbers, each column with about 1000 rows and filled them with numbers. In one of the columns I filled numbers with decimals. Now I would like to have those numbers round them up in that column (integers). I used the function ROUNDUP, but when trying to copy to each other cell, the content in the first edited cell with the function, also is copied into the other cells , which is what I do not want. I want to keep the actual content of every cell, and just add the =roundup() function to every other cell. Can someone help how to solve this?. I guess a VB macro can solve it. Thanks.
Bookmarks