| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Function to control how data displayed
I have 2 columns that I exported from Access to Excel. In Access the columns were Yes or No. In excel they display as True or False. I want them to show as Yes or No what is the function to make this happen? Thank you!! -- LOgle5318 ------------------------------------------------------------------------ LOgle5318's Profile: http://www.excelforum.com/member.php...o&userid=26591 View this thread: http://www.excelforum.com/showthread...hreadid=398606 |
|
#2
|
|||
|
|||
|
LOgle5318,
Assuming your True and False are in columns A & B then In C1 put =IF(A1="True","Yes") and in D1 put =IF(B1 ="False","No") Copy these down the columns as far as you need to. Hide columns A & B. Henry "LOgle5318" wrote in message ... I have 2 columns that I exported from Access to Excel. In Access the columns were Yes or No. In excel they display as True or False. I want them to show as Yes or No what is the function to make this happen? Thank you!! -- LOgle5318 ------------------------------------------------------------------------ LOgle5318's Profile: http://www.excelforum.com/member.php...o&userid=26591 View this thread: http://www.excelforum.com/showthread...hreadid=398606 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| analysing data from alternate columns using the countif function | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) | |||
| What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions | |||
Linear Mode
