Saving Leading Zeros as text

[alans]

I need to save my spread sheet as a text file with | as the seperator. I always loose the leading zeros in a column of numbers or I get my column of numbers including leading zeros with " around the entry, I can't use the file with the " around the field.
Thanks for your help

[carl]

you want numbers to appear with leading 0, perhaps thay are telephone numbers. To do this you need a ' at the front, then its read as text and will be saved like that, leave field delimiter as ' and text delimiter as " (ie the default).
when the csv is opened leave text delimiter as " (ie the default)' , but set the column type heading as text. you should see exactly what you had in the spreadsheet.
_________________
carl
Using OpenOffice.org 2 on XP sp2

[Dale]