Yes/No True/False column formatting

[John Dough]

Am I crazy or wasn't there some way in earlier versions of Excel to format
cells to display only Yes/No or T/F ??

I'm trying to set up some columns with this kind of formatting and can't
find this feature anywhere. I used the Help system and looked up "Data
Validation". That gave instructions for validating data in a list which was
totally worthless (or maybe I'm just too stupid to understand it).

This should be something simple and straightforward. How do you do it?

I'm using Office X, by the way.

[TH]

Try using DATA / VALIDATION

On 4/12/03 16:56, in article BABDE791.2374%p...@dejo.com, "John Dough"

[John Dough]

Do you mean the ONLY way I can do this is to find 2 cells someplace on my,
worksheet, enter Yes and No respectively, and then reference those cells as
a "list"?

This is an "elegant" way to accomplish such a common task with such a
"sophisticated" program as Excel?

I am not impressed. Wonder if it's this bad using AppleWorks -- at least
with that I could set this up in a simple flat file database that probably
has a yes/no data type.

in article BABDF7DB.D2C1%T...@DenverTradingGroup.com, TH at
T...@DenverTradingGroup.com wrote on 4/12/03 4:05 PM:

[J Laroche]

in article BABDE791.2374%p...@dejo.com, John Dough at p...@dejo.com wrote on
2003/04/12 18:56:

Create a custom format (Format/Cells.../Numbers/Custom). In your case,
"YES";;"NO" should suffice if Yes values are positive and No values are 0.

In cell formats, the first part defines how positive numbers are displayed,
the second is for negative numbers, the third is for zero exactly, and the
fourth is for text. Parts are separated by a semi-colon.

JL
Mac OS X 10.2.4, Office v.X 10.1.3

[TH]

Not what I meant. Try this,

Pick the cell you want to be Yes or No.
Choose "Validation" from the "Data" Menu.
Choose "List".
In the "Source" box type: Yes,No
On the "Error Alert" tab put in something like "Must be Yes or No" in the
error message box.

Now when a user picks this cell there will be a dropdown arrow showing and
the only choices are, in this case, Yes or No. If a user tries to type
something else in here they will get your error message.

No wasted cells.

Terry

On 4/13/03 12:20, in article BABEF899.2390%p...@dejo.com, "John Dough"

[John Dough]

Thanks to both TH and J Laroche. Either approach should work fine for me.

Just wondering though...A few years ago I was using Excel 98 on a Wintel
machine and I could swear that there was a cell format called "logical" and
you could specify whether the allowed entries were Y/N, T/F, or 1/0. Am I
imagining this or confusing my recollection of the earlier Excel with some
other program (maybe MS Access) ? If I'm not imagining this then it sure is
puzzling why Microsoft would remove this feature (or perhaps it never was in
any of the Mac versions?)

[Bernard REY]

John Dough wrote :

> Just wondering though...A few years ago I was using Excel 98 on a Wintel
> machine and I could swear that there was a cell format called "logical"
> and you could specify whether the allowed entries were Y/N, T/F, or 1/0.
> Am I imagining this or confusing my recollection of the earlier Excel
> with some other program (maybe MS Access) ?

No, there is no such format in Excel97. But there is indeed in MS Access, so
it is possible that you have mixed up you recollections :-)

There is an even more user-friendly way to perform a Y/N choice in Excel,
it's the checkbox to be found in the "Form" toolbar. It works fine if you
don't have too large a number of lines to deal with.

--
Bernard Rey - Toulouse