View Single Post
  #1   Report Post  
kumarappans
 
Posts: n/a
Default cell format problem

Hi,

I am generating excel automatically using jsp. I am having some of my fields
with leading zeros( like 001,002.. etc). But once I generate the excel the
leading zeros are truncated automically by excel.
My question here is how do i retain this leading zero fields without
changing the field type( as i dont dont change the data type programatically
in jsp). Also i dont want to add any special characters infront of the data.

Pl. help me to retain the field data with leading zeros.

Thanks