Hi

I want to be able to enter a number into a column in excel then drag that number down a number of cells without it going up +1 each time, I just want the number to copy exactly. Is there a way to format the whole column so this does not happen?
ta