Thread: Converting a formulas result to a number

is there a way to convert a result from a formula to a number? like if i have a column with current prices in it and i want to double all those so i create a new column and *2 to each one giving me the new prices but i want to now remove the old prices and just have the newest prices but if i remove it, it removes the formulas result.... is there a better way to do this? the excel sheet is also set up in a book form thing. so it is not just column g with current prices and column h with new prices, it uses several different ones. is there a vba code that would do it better? thanks

Hide the column?

Columns("X:X").EntireColumn.Hidden = True