I'm using a VLOOKUP table with 26,000 six digit coded items. When I use
format cells - text, it doesn't take until I actually double click on the
"text" cell. I can't do this for 26,000 items, I'll go crazy! I tried using
the formula text(A1,"000000") but it doesn't work - just shows the formula as
a text expression in the cell!