This is so quickly done by the fill handle:
http://www.officearticles.com/excel/...soft_excel.htm

Or do you need a macro?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



"Johnny" wrote in message
...
I need to set up a formula for an entire column, not by inserting a
formula on each cell of that column (I've heard that it is possible, but I
couldn't find a clue on how it's done).
For example, I have 2 columns: column A and column B. I want to set
up
a formula for the entire column B, that will divide any number that is
entered in one of the column A cells by 10000.
Hope I've made myself clear enough and that someone could help me on
this.

Thank you in advance