On Wed, Oct 25, 2006 at 12:57:15PM -0700, Ralph Shumaker wrote:
> Well, that's only part what I was trying to tell you. But let me put a
> finer point on it.
>
> Let's say you have a column which has a few numbers already entered in
> general numeric format (behaves like numbers). Then you select the
> entire column and change the numeric format to text. The numbers
> already there continue to behave like numbers. But if you go to one of
> those cells and re-enter the number, when you hit enter, the contents of
> that cell (although it appears no different) will now behave like text.
> What I said was that numeric text formatting does NOT affect data
> already there, but IS applied to any new entry, even the same ascii entry.
>
'Kay.
--
Lan Barnes
Linux Guy, SCM Specialist
Tcl/Tk Enthusiast
History, I believe, furnishes no example of a priest-ridden people
maintaining a free civil government. This marks the lowest grade of
ignorance of which their civil as well as religious leaders will always
avail themselves for their own purposes.
- Thomas Jefferson to Alexander von Humboldt, Dec. 6, 1813.
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list