P
Paul Moles
I want to start a Format, Cell, Number, Custom with three alpha charachters,
I can enter the first two but Excel will not accept the third. Unfortunately
these cells are not contiguous but spread around the sheets/workbook. Is
there a work round or must I be satisfied with just two letters? The benefit
of this is that I can then perform simple +1 calculations on the cells. Also
entry is speeded by only having to enter the number, cell format taking care
of the lettering eg MAT 1, MAT 2,. Any Help appreciated. Thanks Paul. Excel
2002.
I can enter the first two but Excel will not accept the third. Unfortunately
these cells are not contiguous but spread around the sheets/workbook. Is
there a work round or must I be satisfied with just two letters? The benefit
of this is that I can then perform simple +1 calculations on the cells. Also
entry is speeded by only having to enter the number, cell format taking care
of the lettering eg MAT 1, MAT 2,. Any Help appreciated. Thanks Paul. Excel
2002.