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]

Reply via email to