[libreoffice-users] Re: Entering numbers as text in Calc (single quote)

On 15-09-2012 11:02, Leon Stringer wrote:
> 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

This works for me (Version 3.6.1.2 on Windows 7)

The option referred to is probably here:
Tools / Autocorrect options / ......



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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