+ Reply to Thread
Results 1 to 3 of 3

Logical Format showing 0/1 and not True/False.

Hybrid View

  1. #1
    Tony
    Guest

    Logical Format showing 0/1 and not True/False.

    Following my previous question regarding boolian calculations. I now have an
    old worksheet which has been upgraded over the years from "other" packages.
    Results to logical expressions are shown as 0 and 1 as opposed to True and
    False in the worksheet. How can I correct this formatting. (I assume it is
    formatting)

  2. #2
    Harlan Grove
    Guest

    Re: Logical Format showing 0/1 and not True/False.

    Tony wrote...
    >Following my previous question regarding boolian calculations. I now have an
    >old worksheet which has been upgraded over the years from "other" packages.
    >Results to logical expressions are shown as 0 and 1 as opposed to True and
    >False in the worksheet. How can I correct this formatting. (I assume it is
    >formatting)


    Not formatting.

    Tools > Options, select Transition tab, uncheck Transition formula
    evaluation, click OK.


  3. #3
    Tony
    Guest

    RE: Logical Format showing 0/1 and not True/False.

    Thanks. Perfect answer

    "Tony" wrote:

    > Following my previous question regarding boolian calculations. I now have an
    > old worksheet which has been upgraded over the years from "other" packages.
    > Results to logical expressions are shown as 0 and 1 as opposed to True and
    > False in the worksheet. How can I correct this formatting. (I assume it is
    > formatting)


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1