linking a text formatted cell to a formula cell

  • Thread starter Thread starter lacy
  • Start date Start date
L

lacy

in cell A1 i have 00003128 custom formatted as text to 8 characters. in cell
B1, i have =A1&" Equity Sedol1". the problem is that the formula returns
3128 Equity Sedol1 when it needs to return 00003128 Equity Sedol1. text
formatting is not helping. any ideas?

thank!
 
Back
Top