Re: Excel drops leading zeros in a number column/field

2005-12-02 Thread Karl-Heinz Zengerle
Hi Ravi. This way you save the data as strings and don't loose the format. Starting with ' would be sufficient (without using =). You also could save the number and format the cell properly (as you do it if you use Excel directly). You just have to know the exact format. Numbers then still are of

Re: Excel drops leading zeros in a number column/field

2005-12-01 Thread nadiminti ravi shankar
The solution I stumbled upon at the Microsoft website is to use = and double quotes...so the format should be: = __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs --

Excel drops leading zeros in a number column/field

2005-12-01 Thread ravi
Hello List I have a simple feature in my web-application which exports the data from an Oracle Database to an Excel file. I implemented this by: 1. Form the tab separated string and put this in a StringBuffer 2. Set the StringBuffer as a Request attribute 3. In the JSP page, set the content type