[AccessD] OT: Excel Strips Leading Zeros

Thank You Arthur

Just wanted to know if there was a way around this

What a PITA

Thanks again

Have a great day

Darren

-----Original Message-----
From: artful at rogers.com [mailto:artful at rogers.com] 
Sent: Tuesday, 30 January 2007 12:26 PM
To: Access Developers discussion and problem solving
Subject: Re: [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?
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com