poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Calvin Cheung" <cal...@quadbase.com>
Subject Re: Preserving Leading Zero
Date Mon, 03 Feb 2003 21:44:01 GMT
A format such as "00000" will guarantee a five digit number.

Calvin

----- Original Message ----- 
From: "Raghuveer Rao" <raghuveer_rao@yahoo.com>
To: <poi-user@jakarta.apache.org>
Sent: Monday, February 03, 2003 1:34 PM
Subject: Preserving Leading Zero


> I have a column in a spreadsheet which stores
> zipcodes.
> Some zip codes start with zero. I need to store them
> as is. There will be no arithmetic performed on these
> columns and I want to store them as Text. If I use 
> CELL_TYPE_STRING the data is stored as type general.
> So i went in and edited these cells then I loose the
> leading zeros. Is there a reliable way of preserving
> leading zeros.
> 
> I saw some threads here saying that this could be
> achived with some special formats. Can someone post an
> example.
> 
> Thanks
> Raghu
> 
> 
> 
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 



Mime
View raw message