Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 773
  • Last Modified:

Boolean values in xls

I exported from ms sql a table to excel. The boolean values (bit fields) are exported as 0 and -1 but excel does not recognize them as true or false

I need a way to convert these 0'1 and -1's to true or flase
1 Solution
NorieData ProcessorCommented:
Excel does recognise 1/0 as TRUE/FALSE in formulas etc.
You can use the following custom format


This will display your 0/-1 as false True (or the opposite)

Depends whether you need the value to be True, or just the display.


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now