Well one way is to actually do that create a constant

Insert - Name - Define..
Put a name at the top ie "HourlyRate"
at the bottom put =25

Click on Add


Use in any cell or formula by name
ie =HourlyRate
=HourlyRate * A5

etc

Steve

On Tue, 13 Feb 2007 05:58:01 -0000, tkg
wrote:

i want to calculate a series of formulas in rows where all are based off
a
standard number (ie: $25/hr times the various hours worked each day). at
the
moment i have a column with $25 pasted a million times to get a total
sum in
the next column, there has got to be a more efficient way than this to
accomplish?

thanks!