B1: 194
B2: 962
In C2 put in
=(B2-B1)/B1
and format the Cell as Per centage with no decimals.

then select C2 and drag fill down the sheet.

--
Regards,
Tom Ogilvy

"Jeffery" wrote in message
...
I am trying to create a spread sheet showing population changes. For one
of
my lists I show a change in population from 194 in 1990 to 962 in 2000.
The
data source reports this is a 396% increase. How do I format the cells,
B2
to C2, to show this figure automatically as I have a whole list (B3 to C3,
etc) of different counties to figure.
--
Jeffery