F
FritzieK
I am trying to type the name "True" in a name and address database. How do I
get it to type in non capitolized?
get it to type in non capitolized?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CyberTaz
Hi Fritzie-
It helps to format the cells as Text first. That way the program disregards
keywords and operators (even if you type in a valid formula preceded by =).
Unfortunately it will not change the case structure for cells where TRUE has
already been capitalized.
You can reformat the cells and then edit them if not too many or you can use
Find/Replace if necessary. Just be sure to check the box for Match Case.
HTH |:>)
On 6/18/05 4:58 PM, in article
-- [email protected]
It helps to format the cells as Text first. That way the program disregards
keywords and operators (even if you type in a valid formula preceded by =).
Unfortunately it will not change the case structure for cells where TRUE has
already been capitalized.
You can reformat the cells and then edit them if not too many or you can use
Find/Replace if necessary. Just be sure to check the box for Match Case.
HTH |:>)
On 6/18/05 4:58 PM, in article
I am trying to type the name "True" in a name and address database. How do I
get it to type in non capitolized?
-- [email protected]
S
SVC
1. You can change to cell format to Text, then type "true".
2. You can precede "true" with a single quote.
3. If you already have a lot of cells (e.g. in a column) which have "TRUE",
you can insert a new column after this columns, set the format to "Text" and
use the =LOWER function:
If the column with "TRUE" is A, in column B1 type =LOWER(A1) and drag down.
When done, Copy the column and use Paste special, Value to get what you want
(instead of the formula)
2. You can precede "true" with a single quote.
3. If you already have a lot of cells (e.g. in a column) which have "TRUE",
you can insert a new column after this columns, set the format to "Text" and
use the =LOWER function:
If the column with "TRUE" is A, in column B1 type =LOWER(A1) and drag down.
When done, Copy the column and use Paste special, Value to get what you want
(instead of the formula)
F
FritzieK
Hi Cyber Taz
Thank you so much for the information. I am having so much trouble with
excel that I never had with word. People like you that share information are
wonderful!
Thank you so much for the information. I am having so much trouble with
excel that I never had with word. People like you that share information are
wonderful!