I fixed it. I had to use the "=TEXT(A1,"@")" formula for the whole column.
Why would I have to do it that way instead of right clicking and formatting?

"Shane Devenshire" wrote:

Hi,

How about a little more detail, what is the formula in A1, what does it
return to A1, what do you want it to look like in the cell with the TEXT
function? Why can't you format cell A1 directly?

What version of Excel are you using?
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"brett" wrote:

This has more to do with formatting a text string, but how do i format a
column that already has data in it using "=TEXT(A1,"@")"? This is the only
way i have gotten my vlookup to work. It doesn't work just right clicking
and formatting cells. please help. thanks.
brett