software

I want to us 8 V for 8 hours vacation or 8 hours fh for 8 hour floatin holiday.
I'm sure some one has done it just I can't find it

If you just want to give a value to a string (8V - 8FH), you can create
what's called a quot;named formulaquot;.

There are however, some reservations on exactly what strings (names) are
acceptable to XL.

These worked for me:
VAC8
FLH8

Start with:
lt;Insertgt; lt;Namegt; lt;Definegt;,

In the quot;Names In Workbookquot; box, enter
VAC8
At the bottom, *change* whatever is in the quot;RefersToquot; box to:
=8

Click lt;Addgt;

Again, in the quot;Names In Workbookquot; box, enter
FLH8
=8 should *still* be displayed in the quot;RefersToquot; box,
So just hit lt;OKgt;.

Now, if you enter
=vac8
OR
=flh8
in any cell, you'll get 8.

So, you can now have formulas such as:
=A1 vac8
OR
=SUM(A11,flh8)
OR
=vac8 flh8--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===quot;wireed!quot; gt; wrote in message
...
I want to us 8 V for 8 hours vacation or 8 hours fh for 8 hour floatin
holiday.
I'm sure some one has done it just I can't find it
Created fine, but when I enter the vac8 or flh8, I get enter value between 0
- 24?

Imust not be doing something correctly?

quot;RagDyeRquot; wrote:

gt; If you just want to give a value to a string (8V - 8FH), you can create
gt; what's called a quot;named formulaquot;.
gt;
gt; There are however, some reservations on exactly what strings (names) are
gt; acceptable to XL.
gt;
gt; These worked for me:
gt; VAC8
gt; FLH8
gt;
gt; Start with:
gt; lt;Insertgt; lt;Namegt; lt;Definegt;,
gt;
gt; In the quot;Names In Workbookquot; box, enter
gt; VAC8
gt; At the bottom, *change* whatever is in the quot;RefersToquot; box to:
gt; =8
gt;
gt; Click lt;Addgt;
gt;
gt; Again, in the quot;Names In Workbookquot; box, enter
gt; FLH8
gt; =8 should *still* be displayed in the quot;RefersToquot; box,
gt; So just hit lt;OKgt;.
gt;
gt; Now, if you enter
gt; =vac8
gt; OR
gt; =flh8
gt; in any cell, you'll get 8.
gt;
gt; So, you can now have formulas such as:
gt; =A1 vac8
gt; OR
gt; =SUM(A11,flh8)
gt; OR
gt; =vac8 flh8
gt;
gt;
gt; --
gt;
gt; HTH,
gt;
gt; RD
gt; ================================================== ===
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ================================================== ===
gt;
gt;
gt; quot;wireed!quot; gt; wrote in message
gt; ...
gt; I want to us 8 V for 8 hours vacation or 8 hours fh for 8 hour floatin
gt; holiday.
gt; I'm sure some one has done it just I can't find it
gt;
gt;
gt;

When you enter them where? ... how?

Where do you see the error message?

Go to
lt;Insertgt; lt;Namegt; lt;Definegt;

Do you see both strings displayed in the big window?

If so, click on one of them.
Do you see
=8
in the quot;Refers Toquot; box?

If so, do the same with the other string.
Does that also display
=8
?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

quot;wireed!quot; gt; wrote in message
...
gt; Created fine, but when I enter the vac8 or flh8, I get enter value between
0
gt; - 24?
gt;
gt; Imust not be doing something correctly?
gt;
gt; quot;RagDyeRquot; wrote:
gt;
gt; gt; If you just want to give a value to a string (8V - 8FH), you can create
gt; gt; what's called a quot;named formulaquot;.
gt; gt;
gt; gt; There are however, some reservations on exactly what strings (names) are
gt; gt; acceptable to XL.
gt; gt;
gt; gt; These worked for me:
gt; gt; VAC8
gt; gt; FLH8
gt; gt;
gt; gt; Start with:
gt; gt; lt;Insertgt; lt;Namegt; lt;Definegt;,
gt; gt;
gt; gt; In the quot;Names In Workbookquot; box, enter
gt; gt; VAC8
gt; gt; At the bottom, *change* whatever is in the quot;RefersToquot; box to:
gt; gt; =8
gt; gt;
gt; gt; Click lt;Addgt;
gt; gt;
gt; gt; Again, in the quot;Names In Workbookquot; box, enter
gt; gt; FLH8
gt; gt; =8 should *still* be displayed in the quot;RefersToquot; box,
gt; gt; So just hit lt;OKgt;.
gt; gt;
gt; gt; Now, if you enter
gt; gt; =vac8
gt; gt; OR
gt; gt; =flh8
gt; gt; in any cell, you'll get 8.
gt; gt;
gt; gt; So, you can now have formulas such as:
gt; gt; =A1 vac8
gt; gt; OR
gt; gt; =SUM(A11,flh8)
gt; gt; OR
gt; gt; =vac8 flh8
gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH,
gt; gt;
gt; gt; RD
gt; gt; ================================================== ===
gt; gt; Please keep all correspondence within the Group, so all may benefit!
gt; gt; ================================================== ===
gt; gt;
gt; gt;
gt; gt; quot;wireed!quot; gt; wrote in message
gt; gt; ...
gt; gt; I want to us 8 V for 8 hours vacation or 8 hours fh for 8 hour floatin
gt; gt; holiday.
gt; gt; I'm sure some one has done it just I can't find it
gt; gt;
gt; gt;
gt; gt;