What I am actually wanting is the dashes to show up in the formula bar as
they do in the cells for the ss# so when I search for that number by a V
lookup I can find it one list has the dashed and shows up one does not. I
have to format the cells to SS# and once I do that they do not show the dash
in the formula bar .... then I am unable to do the VLookup formula because
the row I am looking up has the dashes.
I am unable to remove the dashes as it changes the entire sheet removing the
zeros out of the SS#
Thanks

"Gary''s Student" wrote:

VLOOKUP() without the "dashes". For example, if E1 thru F4 contains:

123-45-6789 Jim
123-45-6790 Joe
123-45-6795 John
123-45-6799 Janet

then

=VLOOKUP(123456795,E1:F4,2) displays John
--
Gary''s Student - gsnu200850


"norie" wrote:

I formatted cells as SS# but the formula bar does not reconize the dashed
there for I am unable to do a Vlookup from it. What do I need to do to get
the formula bar to reconize the dashed. What can I do otherwise to get the
Vlook up to work.
Thanks,