Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

At 13:54 17/11/2013 -0700, Oogie McGuire wrote:
Or if I know they are text (but there is ABSOLUTELY NO WAY TO SEE THAT IN LO) ...

Er, this is easy, in fact (and shouting doesn't change that!). Providing that you have not imposed any alignment or justification choice on your cells, text will be left-aligned and numbers (etc.) right-aligned. In any case, just go to View | Value Highlighting (or Ctrl+F8). Text values will show in black and numbers (and related quantities, e.g. currency and dates) in blue. These colours show despite existing text colour choices or formatting choices such as negative currency values. You can use this temporarily whilst you are massaging your values and return to normal view afterwards.

All the discussions about the leading apostrophe are great but I still can't see it in LO nor can I remove it.

'Cause it's not there!  (It appears only in the Input Line.)

Yes, I got around the problem this time by creating a dummy column as described many messages ago, ...

That was probably my suggestion, but someone else's Data | Text to Columns... technique is easier and therefore better.

... but the fact remains that it is neither easy to change nor easy to see when numbers are formatted as text in LO ...


Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.