Sounds like you might make use of the dynamic named range in your formula.
have a look at http://www.contextures.com/xlNames01.html for more detailed
instructions. This site has been invaluable to me.

hth

"YMC" wrote:

hi mike, the only problem with that is i do not know the known range of data
that will be in the sheet, like i said there could be 10 cells in a column
with information, or 10000. i dont want to apply the divide function to all
the cells, just kinda sloppy imo. thankyou for the input though.

"Mike H" wrote:

Hi,

Put 60 in a cell and copy it.

Select the cells you want to divide and then

Edit|Paste special
Select divide
Click OK
Delete the cell wit 60 in

Mike

"YMC" wrote:

i am having some trouble adding a math function to a whole column, i know how
to add math functions to cells but in this situation i do not know the amount
of cells there could be. ther could be 10 or 10000 cells with information in
them, i need to divide by 60 to a whole column. how would i go about doing
this. thankyou in advance,