that is exactly the problem. i see a  "h:mm:ss AM/PM"  format and a
"m/d/yy h:mm" .

both formats have most of but not all the precision/fields that i want.

how can i get a "combined" format?

----- Original Message ----- 
From: <[EMAIL PROTECTED]>
To: "POI Users List" <[EMAIL PROTECTED]>
Sent: Friday, October 31, 2003 12:00 AM
Subject: Antwort: date value with m/d/yy h:mm:ss AM/PM format


>
>
>
>
> Hello,
>
> I use it this way:
>
> HSSFCellStyle cs = wb.createCellStyle();
> HSSFDataFormat df = wb.createDataFormat();
> cs.setDataFormat(df.getFormat("dd.MM.yyyy"));
>
> Though you have to find a string representing your "m/d/yy h:mm:ss AM/PM"
> format.
>
> Hope this helps.
>
> Regards,
> Andrew
>
>
>
> |---------+--------------------------->
> |         |                           |
> |         |                           |
> |         |                           |
> |         |                           |
> |         |                           |
> |         |                           |
> |         |  "Tom"                    |
> |         |  <[EMAIL PROTECTED]>   |
> |         |  Received :  31.10.2003   |
> |         |  03:26                    |
> |         |  Bitte antworten an "POI  |
> |         |  Users List"              |
> |         |                           |
> |---------+--------------------------->
>
>---------------------------------------------------------------------------
----------------------------------------------------|
>   |
|
>   |
|
>   |        An:      <[EMAIL PROTECTED]>
|
>   |        Kopie:
                                               |
>   |        Thema:   date value  with m/d/yy  h:mm:ss AM/PM format
|
>
>---------------------------------------------------------------------------
----------------------------------------------------|
>
>
>
>
> i would like to wite write a date value to a cell with "m/d/yy h:mm:ss
AM/PM"
> format. i dont see such a format available in the builtinFormats. how can
i use
> either user-defined-formats or composite formats?
>
>
>
> ---------------------------------------------------------------------
> 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]

Reply via email to