Hi, In the past you would prefix numbers with a single quote to get them treated as text in Calc (and other spreadsheets), i.e. you'd type '123 and see 123 in the cell with the contents left-aligned (in Western LTR languages at least).
Now auto-correct appears to be changing the single quote to a left single quote so it appears in the cell, i.e. you see ‘123 in the cell. In Getting Started with LibreOffice 3.5 it says: If “smart quotes” are used for apostrophes, the apostrophe remains visible in the cell. To choose the type of apostrophe, use Tools > AutoCorrect > Custom Quotes. The selection of the apostrophe type affects both Calc and Writer. But there's no such option (there's Tools > AutoCorrect Options...). I'm alarmed that a way of working that has been common in spreadsheet programs for a very long time has been changed but, does anyone know how number should now be entered as text in Calc? LO 3.6.1 on Win 7. Thanks, Leon -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
