PPRuNe Forums - Excel Column Format Query

PPRuNe Forums (https://www.pprune.org/)

- Computer/Internet Issues & Troubleshooting (https://www.pprune.org/computer-internet-issues-troubleshooting-46/)

- - Excel Column Format Query (https://www.pprune.org/computer-internet-issues-troubleshooting/266905-excel-column-format-query.html)

jethro15

6th March 2007 14:00

Excel Column Format Query

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 March 2007 15:13

Tools > Options > General > tick: R1C1 reference style

jethro15

6th March 2007 15:25

Cheers. Didn't realise that was possible.

All times are GMT. The time now is 11:50.