*snip*
>There is a separate "Text" format in Excel. You would probably have to set this first, and then insert the value. Using the macro editor in Excel, and applying this format, gives me:
>
>
>Selection.NumberFormat = "@"
>
>
>Adapting this to VFP would produce a command similar to the following:
>
>
>oSheet.Cells(lnRow, lnCol).NumberFormat = "@"
>oSheet.Cells(lnRow, lnCol).Value = "2E63"
>
This works perfectly! Many thanks, Hilmar! :)
---------
Single field, surrogate primary keys....because it's sexier!
Third normal form is more than just a good idea.