linking a text formatted cell to a formula cell

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference every 13th cell from another tab. 6
Advanced lookup or match? 1
Create function to find a value in an array in seperate worksheet 1
Converting a Formula stored as String to real Formula 3
Returning values against two criteria 4
Formula with Cell reference to include formating? 13
referenced cells 1
Selection of range for the 'slope' function 1

Top