| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make T=True in a cell, when I enter T
How can I set a formula to recognize a T and automatically place TRUE in the
cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Make T=True in a cell, when I enter T
Hi
=EXACT(A1,"T") -- Regards Roger Govier "A357Magnum" wrote in message ... How can I set a formula to recognize a T and automatically place TRUE in the cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Make T=True in a cell, when I enter T
A formula won't work in the same cell, if that's what you had in mind, but
this formula will work in another cell.... =IF(A1="T","TRUE","") Vaya con Dios, Chuck, CABGx3 "A357Magnum" wrote in message ... How can I set a formula to recognize a T and automatically place TRUE in the cell? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Make T=True in a cell, when I enter T
I sometimes think that it may casue as many problems as it solves but try
Tools Autocorrect and replace t with TRUE. Note that t will replace both T and t with TRUE but T will only replace T and it will leave t as it is. -- HTH Sandy with @tiscali.co.uk "A357Magnum" wrote in message ... How can I set a formula to recognize a T and automatically place TRUE in the cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hit enter in cell & move text down in cell, not go to cell below. | Excel Worksheet Functions | |||
| Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
| enter data in cell but cannot save until click off cell in excel | Excel Discussion (Misc queries) | |||
| Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
Linear Mode
