Tuesday
 

I have a spreadsheet where i need to count the number of the letter "T" in a
row. One row in particular however, will default to "Tue" as though I am
entering a day of the week. Subsequently, the totals column will not
recognize this cell and count the contents, even when I do backspace to get
just the "T" What am I doing wrong??

Tuesday
 

Say that cell is A1. In some blank cell enter "=Len(A1)" without the
quotes. If you get a number greater than 1 then you have spaces (probably)
before or after the T. You can remove the spaces manually or use a formula
like =Trim(A1). Post back if you need more. HTH Otto

"JDay" wrote in message
...
I have a spreadsheet where i need to count the number of the letter "T" in
a
row. One row in particular however, will default to "Tue" as though I am
entering a day of the week. Subsequently, the totals column will not
recognize this cell and count the contents, even when I do backspace to
get
just the "T" What am I doing wrong??