Alpha Charachters in Format Cells Custom

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.
 
R

Ron Rosenfeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom format string from cell value 2
how do i use format cells to alpha / numeric values 2
Excel Named Ranges and Conditional Format 3
Custom Format with different Criteria 2
Remove Alpha from AlphaNumeric String... 9
Merge cells time format 4
Use custom format to add text to a text entry. 4
Custom formating of cells 2

Top