Alpha Charachters in Format Cells Custom
 

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.

Alpha Charachters in Format Cells Custom
 

On Sat, 16 Feb 2008 00:57:09 -0800, Paul Moles
wrote:

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.

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

Alpha Charachters in Format Cells Custom
 

Putting the letters inside quotation marks works fine. Thanks Paul

"Ron Rosenfeld" wrote:

On Sat, 16 Feb 2008 00:57:09 -0800, Paul Moles
wrote:

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.

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

Alpha Charachters in Format Cells Custom
 

On Sat, 16 Feb 2008 04:15:00 -0800, Paul Moles
wrote:

Putting the letters inside quotation marks works fine. Thanks Paul

You're welcome. Glad to help. Thanks for the feedback.
--ron