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 ?
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
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.
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
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
Pasting works... thanks... is there an easy way for it NOT to show the No's.... just the "Y"es's ?
Hi, Try "Yes";Yes";""
The previous "No" is now a pair of double quotes
Regards
that did it.... YouDaMan... Thanks for the assistance.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |