A format such as "00000" will guarantee a five digit number. Calvin
----- Original Message ----- From: "Raghuveer Rao" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
