Give it a custom format of:
X;X;X;X
Dr. Darrell wrote:
Thank you, that works.
Now I need to format my cells to display " X " no mater what character is
typed in.
Darrell
"B. R.Ramachandran" wrote:
Dr. Darrell,
If you want to count the cells that contain any character (numbers as well
as strings), use =COUNTA(C4:Z4)
Regards,
B.R.Ramachandran
"Dr. Darrell" wrote:
I have a count function; ( =COUNT(C4:Z4) )
I have my cells formated to display an (" X ") for any number that is entered.
The function works well. But, I'd like to know if there is a way I can type
any character into the cells instead of just numbers? (I'd like to have the
"any character" be displayed as (" X ")).
Darrell
--
Dave Peterson
|