You might try a named formula.
From the Menu Bar,
<Insert> <Name> <Define>
In the "Names In Workbook: box, type
numb
*Change*whatever's in the "Refers To" box to,
=5
Then <OK>
Now, in any cell enter,
=numb
And you'll get a return of 5.
So,
=10*numb
Will return 50.
=numb/2
Will return 2.5
To change the value, just repeat the above procedure and change the value in
the "Refers To" box.

Signature
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
> Can you please show me how to set up a simple variable in Excel, but this
> variable must be cell location independent. Because this worksheet will be
[quoted text clipped - 9 lines]
>
> Thank you.
Alberta K. - 19 Dec 2007 01:36 GMT
Great. Thank you very much.
> You might try a named formula.
>
[quoted text clipped - 20 lines]
> To change the value, just repeat the above procedure and change the value
> in the "Refers To" box.
RagDyeR - 19 Dec 2007 15:55 GMT
You're welcome, and thank you for the feed-back.

Signature
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
Great. Thank you very much.
> You might try a named formula.
>
[quoted text clipped - 20 lines]
> To change the value, just repeat the above procedure and change the value
> in the "Refers To" box.