Hi, How to read data in an excel (2003/2007) which has special formatting (like currency, zip). I see that data with 'zip' formatting is being read as INTEGER, but in the process it loses the actual data. For example, '01805' is a zip code in US, but when it is read using POI 3.2/3.6- it is read as 1805- removing the leading zero. Please suggest if any solution is possible in POI or workaround.
Thanks n regards, Rajiv
