Harold Fuchs wrote:

Not sure if this is the quickest way but ...
Save the file as a .csv (Comma Separated Values) file. This will save your values as strings surrounded by quotes and separated by commas. Each row will start on a new line. Close Calc. Open the .csv file in a text editor (or Writer) and change all the quotes to nulls (the empty string - *nothing* in the "replace with" box). Save the result as another .csv file (or overwrite the original if you are brave enough).

Cheers, Harold. That worked well.


Pierre


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to