Cell with formula won't overflow

[Zanatos1986]

Hey all
I have a cell B3 that is using an equation to reference another sheet. I need this cell to overflow into cell C3. This is a number, it displays correctly when in 99999 and under numbers, however, once I go into 100000 and over numbers it truncates to 1e+05. I cannot have this. Changing the type to number displays it as ####. Cell C3 has nothing in it, I have deleted/cleared cell and everything. B3 and C3 are not merged in any way. No text rotation. The sheet does not have the "show equations" checkbox on. I cannot find any reason why B3 wouldn't overflow into C3.

The odd thing... I have 18 different sheets that share this format, all created from this first one (copy/paste/change references). The first one is the only one that will not overflow into C3, the other 17 do! I cannot figure this out. Any help is extremely appreciated.

Excel 2016 / Windows 7

 

[FormR]

Hi, I think that's standard behaviour for numbers, whether from a formula or not. You could convert the result to text - but you should be aware that if you intend to do any further calculations with it this might cause problems.

For example, to convert to text you could append a zero length string to the beginning of the number:

=""&Sheet1!A1