formula replaces text

[mikecox39]

I have a lists worksheet with an account listing in A13.
In my Master worksheet I have an account column with that account name in cell A18.
In the details page that account doesn't display in the accounts column
I entered =Lists!A13 in cell A18 on my Master worksheet, the account name went away replaced by the formula.
There is no listing of that account, in cell A18, n the Details page.


Not sure what I'm doing wrong. I've managed to accomplish this, when I created the spreadsheet, to the accounts appear in the Accounts dropdown. I am simply trying to add a new account listing, so I will appear with the rest of the Accounts in the Details list.

 

[mole999]

my guess would be the cell is formatted as TEXT

 

[mikecox39]

The entire Accounts column is formatted for Text and all the cells in the column have a formula with text.

How do I get the formula to remain active in the cell in question while it displays the name of the account, like all the other cells in the column?

 

[mole999]

I would copy and paste another cell that works onto it and make it reset

 

[mikecox39]

Well that didn't work so I inserted a new row and entered the Lists!A13 formula and it added the text from A13 in the Lists sheet into the cell.

Strange

Thanks for help.