On Mon, 2010-03-01 at 12:34 +0100, Andreas Saeger wrote: > When you paste zip-codes from a decent application (database?) the > clipboard data are marked as text and Calc will treat them as text in > this particular case.
> When you enter a sequence of digits into a cell it treats the sequence > as number. bg: That certainly would make sense, but as I mentioned to Brian, that was decidedly *not* the observed result. Some .cvs imports were formatted as numbers, while other .csv imports were text. And some of my manually entered ZIPs showed as numeric, but others came out as text. Part of the remaining confusion (not that it really matters, as the substantive portion is now solved) is that glaring lack of a consistent, predictable pattern. Unresolved inconsistencies in software always make me nervous :-) Although I fully realize that such inconsistencies are often ultimately explained by uncovering some lack of knowledge on the part of the observer.... .... danke for your help and observations. Brewster -- *********************************************************************** Embrace a sharing community of sustainable justice low-carbon diversity *********************************************************************** W. Brewster Gillett b...@fdi.us Portland, OR USA *********************************************************************** Simply because you don't like to hear it, that doesn't make it untrue. *********************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
