Right button click on the column in excel and goto FORMAT CELLS change it
to TEXT
At 06:57 PM 5/19/00 +0100, you wrote:
>I have to import some data from an Excel spreadsheet into an Access
>application.
>
>One of the cols is in the following format.
>
>eg
>
>2925
>240
>249
>602
>3559
>252
>408
>417
>667
>2926
>410
>60692
>
>The original data source had these like so
>
>002925
>000240
>000249
>000602
>003559
>000252
>000408
>000417
>000667
>002926
>000410
>060692
>
>
>I would prefer to reinstate these leading zeros. These are and
>will be a Unique key Index. The original source allows export to
>Excel but when copying into Excel removes the leading zeros:)
>
>This is a monthly update requirement and it may be that some time
>in the future we will need to use these numbers to link to other
>sources using this field as the link hence my need to keep the leading zeros.
>
>Any and all suggestions received with the usual enthusiasm and gratitude!
>
>Gordon
>
>
>
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.