I would include the dollar sign with the number being sought, $150, but I
wouldn't bother with the number it's replaced by, since Excel automatically
inserts them in the series formulas.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Saxman" wrote in message
...
Jon Peltier wrote:

I often have to make changes like this, so I wrote a little utility to
help:

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

I would replace $150 with 16,

No $? Just 16?