Are you quoting the value? I also believe that adding a single quote at the beginning of the string forces Excel to treat it as text but doesn't display the single quote itself.
On Jan 11, 2008 8:07 PM, Dominic Watson <[EMAIL PROTECTED]> wrote: > > > > I need to convince Excel that this is *not* a number of any kind, but > > just a string. I can trick it by doing something stupid like > > ###getCERTIFICATION.certNUM# = which adds a non-numeric character, but > > I'd prefer not to do that. > > > > Ideas? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
