RE: How to get "12345" to be a real string?

[Andy Lee]

At 1:37 PM +0800 2/4/03, H@rry wrote:

I set directly using this

	HSSFCellStyle cs = cell.getCellStyle();
      cs.setDataFormat((short)49);
      cell.setCellValue("12345");

All values entered in the cell will be treat as text...no matter wat you key
in.

Thanks, that works.

Can you explain what is going on, and how you arrived at the magic number 49?

How does this data format preserve the "stringness" of the field without showing a leading apostrophe? I would have expected the field to show up as

'12345

when I double-click it, but it shows up as

12345

--Andy

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]