Something weird going on

[Carty]

Hi.

On a previously created worksheet I enter a value of 50 into A1 and press return

The value appears in C1 as if A1 to D1 have been merged and centred

There is no formula in C1 and no obvious formatting in A1

Does anyone know how Excel does this?

Paul

 

[etaf]

it may be not merged but centred cross selection, under formatting

 

[Carty]

So it was. Thanks. I've not come across that before

 

[Carty]

If cell contains a formula that points to a blank cell any idea why the cell displays 0?

 

[RoryA]

That's just the way it works.