[Novalug] Spreadsheet Problem (Dan Arico)

[Roger W. Broseus]

Dan,

I tried formatting such data as text, general, and others. Didn't change a
thing. If you put an appostrophe in front of the numbers in a cell, the
contents should be treated as a string. One could probably create a
function to concatenate an appostrophe with the contents of a cell and put
the result in a new cell.

-- 
Roger Broseus
   RogerB at bronord.com
   www.bronord.com

On Thu, April 8, 2010 8:54 pm, novalug-request at calypso.tux.org wrote:

>    2. Spreadsheet Problem (Dan Arico)
> ------------------------------
>
> Message: 2
> Date: Thu, 8 Apr 2010 19:14:58 -0400
> From: Dan Arico <dan_arico at aricosystems.com>
> Subject: [Novalug] Spreadsheet Problem
> To: Novalug <novalug at calypso.tux.org>
> Message-ID: <201004081914.58115.dan_arico at aricosystems.com>
> Content-Type: text/plain;  charset="us-ascii"
>
> Somebody sent me a mailing list as a csv file. It opens just fine, either
> as a
> spreadsheet or a text file. My problem stems from the fact that zip codes
> are
> not being treated consistently. A nine digit zip with a hyphen in it is
> treated as a string. A five digit zip is treated as a number. I need a way
> to
> force it to be treated as a string.
>
> Any ideas?
>
> Dan