i am tying to add the same data to a number of cells in a column say £2.42, i am having to type in each cell, is there a way to drag this data in without it adding up. thanks
I can think of two possible solutions; hold Ctrl while you drag the little handle, or copy/paste into a selection of cells.
If this answer helped you, please accept it by clicking the check mark 
to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.