ExcelBanter - linking a text formatted cell to a formula cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - linking a text formatted cell to a formula cell (https://www.excelbanter.com/excel-discussion-misc-queries/231686-linking-text-formatted-cell-formula-cell.html)

lacy

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!

Sean Timmons

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!

All times are GMT +1. The time now is 07:53 AM.