Forum Discussion
Enter formula in Excell table cell
Hi Hans--
Here is a link to a sample workbook (https://1drv.ms/x/s!ApdC8bCEGKkjh9EPH4canb316oSZ8w?e=Hnqpi3). It has two sheets: "Copy" is a copy of the sheet from my original workbook with the sensitive data replaced and then an additional range added to calculate the House ID. "Test" is new sheet with the same data all manually entered and then a copy made and converted into a table.
The table in the "Copy" sheet still shows the problem while the table in the test sheet does not.
It looks like there is some property of the original table that prevents its copy from acting properly.
Any help would be appreciated.
Barry
Thanks!
The cells in the HouseID column on the Copy sheet have been formatted as Text, while those in the same column on the Test sheet are formatted as General.
If you enter a formula in a cell formatted as Text, it will remain just a piece of text instead of operating as a formula. So:
- Format the HouseID column as General.
- Redo the formula in B4.
- Fill down.