Try this:

ToolsOptionsEdit tab, check Extend data range formats and formulas

Do read HELP to understand how and under which conditions it works

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"YMC" wrote in message ...
|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,