PDA

View Full Version : Excel Column Format Query


jethro15
6th Mar 2007, 14:00
Does anyone know how to change the column headings in Excel from A, B, C.....etc to numeric 1, 2 , 3. and back again?.

ExGrunt
6th Mar 2007, 15:13
Tools > Options > General > tick: R1C1 reference style

jethro15
6th Mar 2007, 15:25
Cheers. Didn't realise that was possible.