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 ...
Hmm! Brian Barker -- To unsubscribe e-mail to: users+unsubscribe@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