Another thought. If your 52000 is in cell A1 type =$A$1/12 in the September
column and copy across.

--
Ian
--
"John" wrote in message
...
I have a total amount of $52,000 and I want to show an equal amount in
twelve
columns which represent 12 months from sept 2005-sept 2006. My calendar
goes
for 3 years, jan 2005- jan 2008. How do I get this amount to show up in
the
correct columns.