Thread: linking a text formatted cell to a formula cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
  
Posts: 1,696
Default linking a text formatted cell to a formula cell
=Text(A1,"00000000")&" Equity Sedol1"

"lacy" wrote:

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