| || |
excel format issue - converting 0&1 to True&False
Hi. Thanks in advance for your response. I am doing SQL queries and outputting the retrieved data to an Excel spreadsheet. Have one query that returns a 0 and a 1; when writing out to Excel, it instead writes TRUE or FALSE instead of 0 or 1. I am formatting the values in the column to a be a number format, but it remains TRUE or FALSE. Would appreciate any suggestions. When trying to format the output in the spreadsheet manually, same result as when doing programatically. Thanks.
objExcel.ActiveSheet.Range(ColumnLetToFormat & "4:"&ColumnLetToFormat&TableRow_Cnt+3& "").NumberFormat = "#,##0"
Re: excel format issue - converting 0&1 to True&False
Try to add (') symbol before 0 and 1 in Excel sheet