Actually, you could set up Named Constants....
Here's how:

InsertNameDefine
Names In Workbook: Plate
Refers to: =0.5
Click OK

Now you don't have to worry about accidentally deleting or writing over a
cell with that value.

Use it like this:
A1: 10
B1: A1*Plate <----results in 5

Does that help?

***********
Regards,
Ron


"JWDesigns" wrote:

I'm using different material "plate, angle, tube steel" I would like to
assign a number value to that text. ie. plate would equal .5 Is there a way I
can do this?