Maintaining Text Entries
Desktop Apps Training - Calc

Previous / Next


At times you may enter text and find that as soon as you click enter it is altered in a fashion that you did not want. For example, you enter the text MAY but when you click enter the program automatically changes it to May, but you really wanted all caps. One way to fix this is the add a single quote before your text, like this 'MAY. When you click enter the single quote disappears and the letters are like you wanted. The same thing happens when you start a number with 0, it will automatically be erased. If you were entering zip codes in a spreadsheet that started with 0 you would be out of luck. Instead, place the single quote in front of them.