Thread: linking a text formatted cell to a formula cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lacy lacy is offline
external usenet poster
  
Posts: 11
Default linking a text formatted cell to a formula cell
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!
Reply With QuoteReply With Quote