[AccessD] OT: Excel Strips Leading Zeros

Bryan Carbonnell carbonnb at gmail.com
Tue Jan 30 09:19:12 CST 2007


On 1/29/07, artful at rogers.com <artful at rogers.com> wrote:
> Because Excel sees them as numbers, not strings. Wrap the values in single-quotes.

You don't need to wrap then in single quotes. You can just precede it
with a single quote.

It's a holdover from 1-2-3 compatibility, IIRC

-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"



More information about the AccessD mailing list