Hello,

I'm trying to convert a cell that is Numeric with a formatting string that 
makes it look like a phone number.
The format string is "###\-###\-###".

String formatString = formats.getFormat(cell.getCellStyle().getDataFormat());
DecimalFormat dc = new DecimalFormat( formatString);
System.out.println( dc.format(cell.getNumericCellValue()) );
System.out.println( formatString );


I'm missing a concept here because the output is not what you would expect when 
the inputs are effectivly:

###\-###\-#### 
5.0888522E9    (toString() of the cell)

Anyone point me in the right direction?  Am I using a format that isn't 
supported by Java formatting classes?  Is there a util class someplace in the 
library that would help me out?

I don't normally code in Java (hence not familiar with the format stuff) and I 
did search through the archives but didn't turn anything up.

Cheers,
  Shane





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

Reply via email to