Formatting cells

Microsoft Excel 2003 (full product)
January 5, 2010 at 14:04:57
Specs: Windows XP
Have an Excel spreadsheet that's linked to an access database. Using a query (get's all records) I populate the spreadsheet. One of the fields in the database is a Y/N field. When it's brought over into Excel, depending on the format of the cell obviously, it displays as a 1 or zero.... 1 if it was yes, zero if it was no. How can I change the format to show Y or N in that Excel cell ?

See More: Formatting cells

Report •


#1
January 5, 2010 at 14:12:31
Hi,

Format the cell using the Number - Custom format: "Yes";"Yes";"No"

It was near the bottom of the custom formats in my list

Regards


Report •

#2
January 6, 2010 at 09:51:02
I don't see that option under "Custom". I'm using Office XP (2002) and when I highlite the column and right-click and choose "Format Cell" I have a custom but there's no Y/N, just a bunch of number and date formats.
There is a custom that shows # ?/? but it doesn't cause the 1/0 to display any differently.

Report •

#3
January 6, 2010 at 10:04:42
Copy this to the clipboard:

"Yes";"Yes";"No"

In Excel choose Format...Cells...Custom

In the Type box, highlight whatever is in there and paste the "Yes";"Yes";"No" in.

Click OK



Report •

Related Solutions

#4
January 6, 2010 at 10:18:20
Hi,

It may not be possible to paste into the Type box, so just type it in.
Double quotes are required as shown, and the two semicolons are required.

Regards


Report •

#5
January 6, 2010 at 12:30:45
Pasting works... thanks... is there an easy way for it NOT to show the No's.... just the "Y"es's ?

Report •

#6
January 6, 2010 at 13:25:59
Hi,

Try "Yes";Yes";""

The previous "No" is now a pair of double quotes

Regards


Report •

#7
January 6, 2010 at 13:33:02
that did it.... YouDaMan...

Thanks for the assistance.


Report •

#8
January 6, 2010 at 14:10:42
You're Welcome

Regards

Humar


Report •


Ask Question