Hi Tim. Unfortunately we can't assume that. We import Excel files in a variable way to database table and also export them in a variable way. Thus we can't know where which datatype comes (resulting in a special format in Excel).
But I've the following idea: Is it possible to query that special format (Let's say an empty cell will be formatted like this) and use that queried format for another cell? Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Tim Wilkins [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 3. M�rz 2004 16:07 An: POI Users List Betreff: Re: non-built-in date format In Excel use the "Custom Format" option under the cell properties (I'm assuming you are using a template to specify format). You can create your own custom date formats there. I managed to get your format working in my spreadsheet by doing this :) Karl-Heinz Zengerle wrote: > Hi world. > > How can I output a date in the format �dd.MM.yyyy� to a cell? > According to the documentation this isn�t a built-in-format. > > With another format it�s already running fine but I�m sure that users > don�t want to see that notation. > > MfG > > Karl-Heinz Zengerle > > ___________________________________________________ > > */More than competence in Document Management/**/ > /*___________________________________________________ > > SAW AG > Waldm�nchenerstr. 12 > 81549 M�nchen > Tel.: ++49-89-68088368 > Fax: ++49-89-68088389 > www.sawag.com <http://www.sawag.com> > > > > ___________________________________________________ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
