Thankyou RD, it works perfectly well, the only thing that would work better
is if I could actually conditional formatt a cell to return a numerical
value, or a combination of numbers and text. It's nice that the other
respondant complimented you on your solution.

Dantron

"Ragdyer" wrote:

You can try using a named formula.

From the Menu bar:
<Insert <Name <Define

In the "Names In Workbook" box, enter:
A
In the "Refers To" box, change what's there to:
=8
OR
="8FF"

Then click <OK

NOW, type
=A
OR
=a
in any cell, and you'll get your
8 or 8FF

If you chose to use the number
8
You could use it in calculations, such as:
=25*A
to get a return of 200

If you used the 8FF,
="The part number is "& A
to get a return of:
The part number is 8FF

--
HTH,

RD

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

"Dantron" wrote in message
...
If I want to type a letter in a cell, can I have that cell convert the
letter
to a number ?example, type in A1 the letter A and have A1 return the
number
8, or 8FF I am using Excel 2003