Cannot use a certain number on excel

Copper Contributor

Need someone's help please!

 

I have an excel spreadsheet that has a master tab and then sub tabs where the data then feeds into the master automatically by a formula. I have just added some new data on to the master and the sub tab and inputter the formulas but for some reason out of the 14 addresses I added with unique property numbers, excel is not allowing me to use 1 of these numbers, i can type any other 8 digit number in and the spreadsheet will link but as soon as I use the number I need to use the 2 sheets stop speaking to each other. They all have the same formula as it has just been copied and all other cells/rows/columns are updating. 

 

The only way to have them linked is if i do a -8 at the end, if i try to just put the 8 normally it stops linking the sheets and its driving me mad!

 

EmmaPaul_0-1727876128330.png

Thanks

 

Emma

1 Reply

@EmmaPaul 

Perhaps formula automatically converts the text 00809038 into number 809038. Which formula do you use?