Haroldm 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 ?
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.
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Compnet Ventures, LLC hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.