You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Lior Shliechkorn <li...@yahoo.com> on 2003/04/24 19:27:44 UTC

Changing the field data type

I'm running into a problem with the data types being entered into the cells. I'm populating the fields from a database and the numbers, when inserted into the cells, are already being formatted by a special class file we created. When I open the excel file, I see a bunch of green triangles by every number, with the error "Number stored as text." How can I just format the datatype to be a number, while not affecting the formatting we've done to the number with the class file. For example, after we retrieve and format a double from the database we get $5,000 (which is a string after we format it). I want it to just show 5000 in the excel file without the triangle. Thanks,
Lior


---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.