[AccessD] OT: Excel Strips Leading Zeros

Because Excel sees them as numbers, not strings. Wrap the values in single-quotes.
 
Arthur Fuller
Technical Writer, Data Modeler, SQL Sensei
Artful Databases Organization
www.artfulsoftware.com




----- Original Message ----
From: Darren DICK <darrend at nimble.com.au>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Monday, January 29, 2007 8:04:32 PM
Subject: [AccessD] OT: Excel Strips Leading Zeros


Hi Team - Brains Trust Q



Can anyone tell me why excel strips leading zeros from the cells?