I have a column of numbers that are created from a formula. I need to copy those numbers into another spreadsheet as whole numbers (not as a formula). Is it possible to do, if so how?
Thanks
I have a column of numbers that are created from a formula. I need to copy those numbers into another spreadsheet as whole numbers (not as a formula). Is it possible to do, if so how?
Thanks
select the range to copy and on the other sheet you paste as special, right click on any column then select phase special and tick values click ok
Thats great! Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks