Not using data validation alone. You might be able to work something up in
the worksheet change event that reacts to the entry and changes it to the
code alone

Private Sub Worksheet_Change(ByVal Target As Range)
if target.count 1 then exit sub
if target.column = 2 then
On Error goto ErrHandler
Application.EnableEvents = False
target.value = "(" & Mid(Target.Value,2,1) & ")"
end if
ErrHandler:
Application.EnableEvents = True
End Sub.

--
Regards,
Tom Ogilvy

"Spongebob" wrote in message
...
I am running a validation on a cell for a particular code to be used for a
timesheet. For the finished result I need just the code to show up in the
cell, however there are quite a few codes and they are difficult to
remamber.
Is there a way to have the drop-down list display the description (S -
Schematic Design) but then have the result of the drop-down be just the
code
(S)?

Thanks in advance,
Jeffrey K. Ries