If you have a formula like =4*B1 (or =4*B$1, or 4*$B$1, or =4*$B1), the
number 4 in the formula should not change when you drag it down, so I don't
understand your question.
--
David Biddulph

"jeel" wrote in message
...
When writing formulas I use the $ to make it stay the same when I drag it
down.
If a number is part of a formula, is there a way to make a number stay the
same when dragging down? Thanks jeel