Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.

Hazarding a guess that
the dollar sign ($) is what you're after here

Maybe you mean something like this:

You've got numbers in A1:A9, with the total in A10
[ in A10: =SUM(A1:A9) ]

Then in B1: =A1/A$10

B1 is formatted as percentage,
and copied down to B10
to return the corresponding percentages

The $ sign in A$10 will fix it to the row10 where the total cell is in col
A. Hence this part won't change when B1 is copied down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbog" wrote in message
...
Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.

You need to make the cell reference for the second cell absolute - you
use the dollar symbol $ for this, for example:

=A2/A$1

When you copy this down it will become:

=A3/A$1
=A4/A$1

etc.

Hope this helps.

Pete

dbog wrote:

Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.

Yes, that's it!! Thanks to both of you so much. It saves me a ton of
copying and pasting.

"Max" wrote:

Hazarding a guess that
the dollar sign ($) is what you're after here

Maybe you mean something like this:

You've got numbers in A1:A9, with the total in A10
[ in A10: =SUM(A1:A9) ]

Then in B1: =A1/A$10

B1 is formatted as percentage,
and copied down to B10
to return the corresponding percentages

The $ sign in A$10 will fix it to the row10 where the total cell is in col
A. Hence this part won't change when B1 is copied down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbog" wrote in message
...
Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.

You're welcome !
Thanks for feeding back to us ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbog" wrote in message
...
Yes, that's it!! Thanks to both of you so much. It saves me a ton of
copying and pasting.