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.