I am trying to reference another cell in the custom format area. how it
is seet up currently, I have a column (A) that will have the quantity,
column (B) has the unit of the quantity, and column (C) has the unit
price, followed by column (D) that will have the total cost of the
object (i.e. column A * C = D)

I am trying to have column C set up so all I have to do is type the
unit price but the custom format of the cell will change the value to
include the label that is in the column next to it (B).......currently
for examples sake, I am trying to set the unit price to 50, and the
unit of the quantity will be tons. ideally the result after simply
imputting 50 into the cell it will display $50/ton.

I could get it to display this simply for this case, by changing the
custom format of the cell, but since the units will change from ton to
sf. or lf....etc I am looking for a more permanent
solution.......Please help!


--
lil_ern63
------------------------------------------------------------------------
lil_ern63's Profile: http://www.excelforum.com/member.php...o&userid=23219
View this thread: http://www.excelforum.com/showthread...hreadid=400974