Alpha Charachters in Format Cells Custom

  • Thread starter Thread starter Paul Moles
  • Start date Start date
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 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.
Click to expand...

There should be no problem related to the number of letters being entered. Did
you put the letters inside quotation marks? Or precede them individually with
a slash?

How, exactly, did you try to make the entry?


--ron
 
Back
Top