Ask Experts Questions for FREE Help !
Ask
    V34's Avatar
    V34 Posts: 3, Reputation: 1
    New Member
    		  
    #1

    Feb 2, 2010, 07:57 AM
    Spreadsheet entry
    Filling in spreadsheets: the word true always enters as TRUE although it is entered in lower case. This does not happen with any other word.
    cmeeks's Avatar
    cmeeks Posts: 754, Reputation: 64
    Senior Member
    		  
    #2

    Feb 2, 2010, 02:57 PM

    It appears in all caps in Excel and OpenOffice.org
    Because "TRUE" is a Boolean operators and spreadsheets use Boolean operators the case is always set to upper case because the Boolean Operator needs to be upper case. The same applies to "FALSE"
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Spreadsheet link [ 3 Answers ]

How to link one spreadsheet with another, so when entering data in one spreadsheet This data affect the another ones?

Journal Entry / Double-entry software needed [ 5 Answers ]

Hi, I am looking for a good software to use for daily journal entries and adjustments, that will allow me to create at least a balance sheet & income statement and perhaps a few reports (like inventory, accounts receivables). I need a real double-entry & simple reliable software. Peachtree &...

What do I debit/credit in journal entry/adjusting entry? [ 1 Answers ]

Hi. I am unsure about the correct way to debit/credit these entries. Can someone help me? Window Washing Company opened on July 1, 2010. During July the following transactions were completed: July 1 Issued 14,456 shares of common stock for $14,456 cash. July 1 Purchased used truck for...

Excel Spreadsheet [ 1 Answers ]

I need a macro or something for a website that has a excel spreadsheet. My client has a excel spreadsheet out on a website. They have invoice # on the excel spreadsheet and want to be able to scan the invoice and have it linked to the invoice on the website so clients can see the scanned document....

No spreadsheet [ 4 Answers ]

I have a new computer with windows vista. There is no spreadsheet with it like there used to be on computers. Is there a free way to get a spreadsheet system in my computer. I use spreadsheets some but not enough for me to buy anything to get it to work.

View more questions Search