[AccessD] OT: Excel Strips Leading Zeros

Michael Maddison michael at ddisolutions.com.au
Tue Jan 30 22:06:43 CST 2007


Ah,
is that why I sometimes see csv files with a leading ' in the text?

cheers

Michael M

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!"
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list