Are you saying that you would like to extract the number part of the
cell? If so, then assuming that your pull-down is in G1, then this
formula will give you the numerical part of it:

=-("("&MID(G1,SEARCH("$",G1)+1,255))

so if you have "Yard ($800)" in G1, this will return 800 in the cell
with the formula.

Hope this helps.

Pete

On Oct 2, 10:23 pm, Steve_Dallas
wrote:
I'm in the AV business and I am creating a room/speaker worksheet where on
Sheet 1, there is a drop down cell for each room that references a list from
Sheet 2 of (1) available speaker types and (2) the added price so that I can
chage it from time to time. Column A would be Classic, Architectual, Extreme,
Yard and column B would be $0, $400, $600, $800 respectively.

The resulting drop down name on Sheet 1 would be a combination of the 2
columns from Sheet 2. For example "Classic ($0)" or "Yard ($800)" with the
parenthesis.

Once 1 of the 4 is chosen, I would like that cell to have the dollar value
that it represents so that after selecting the type of speaker for each room
there will be a total of added expense at the bottom of the form.

Thank you in advance!