Export number with leading zero to Excel

[Walter Vaughan]

Robert T. Repko (R Squared Consultants) wrote:

> Thanks Bob, that does keep the leading 0.  I would like to allow them to 
> simply double click on the csv file to open it in Excel but this will 
> probably have to do.

Does it really have to be a .csv? What about .slk?

It's not that tough to create what you need directly with from filepro...

ID;PSCALC3
C;X1;Y1;K"01"
C;X2;Y1;K2
E


Verbal explanation..
line1) Header. Seems to be consistent
line2) Put the text value "01" in A1 (x1,y1) cell
line3) Put the numeric value 2 in B1 (x2,y2) cell
line4) End of file

You get full control... put stuff where you want. Excel knows what to do with file.

.slk opens up in ExcelXP and OpenOfficeCalc 2.0 for me.

Or start developing in frameworks that *natively talk* .pdf/.xls/.doc ...

--
Walter