Cell referencing don't work in Excel!!!!!

C

Ctech

Hi guys,


I normally copy down formulas in Excel by double klicking the buttom
right corner of a cell...


When I do this now, everything works as normal, however all cells gets
the same value. (i.e. =Left(A1,4) )

PS!! Im NOT using $A$4 formula...


Sa even though the formulas is like this...

=LEFT(A1,4)
=LEFT(A2,4)
=LEFT(A3,4)
=LEFT(A4,4)
=LEFT(A5,4)


Copy of A column:

4111 - External completions
4112 - Credit notes - External completions
4121 - Intercompany sales
4122 - Internal sales
4511 - Other income
4512 - Intercompany other income
4521 - Internal other income - commercial time
4522 - Internal other income - service time
4523 - Internal other income - service costs
4531 - Group overhead recovery
4532 - Regional overhead recovery
5101 - Interviewer fees (invoiced, no employment contract)


I still get 4111 for all the formulas... why?
 
Top