Lan Barnes wrote: > On Mon, Oct 16, 2006 at 01:01:59PM -0700, Carl Lowenstein wrote: >> Oh. Penny drops. Can't you specify that the column in the >> spreadsheet is of type alpha, not type numeric? >> > > That is what I'm asking. >
I think you have to force interpretation as text rather than numeric. There may be a conversion function you can call by executing some macro? If you are typing the data in, you can type '901, '88, etc (prefix=single-quote) to force text. If importing from a file, you have to help the import wizard for that column, by specifying text. Regards, ..jim -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
