Hi Bill, I don't know if this will help with your automated solution, but prefixing the value with an apostrophe will cause Excel to treat it as a string, and not display the apostrophe. This is a "throwback" to the old Lotus 1-2-3 convention that made the cell contents a "label."
Hope this is of some use! Dave Dave Sebaste Sebaste Studio and Carolina Artisans' Gallery Charlotte, NC (USA) [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> http://www.CarolinaArtisans.com <http://www.CarolinaArtisans.com> ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]