Hi, Try &nsbp; before the job number.
HTH, Elyse http://www.anticlue.net On Tue, 4 Jan 2005 23:03:51 -0700, Shawn <[EMAIL PROTECTED]> wrote: > I'm creating an HTML table, and setting the mime type of the page so that it > is treated as an MS Excel file. This has been working great except for one > little gotcha. > > One of the columns has a "job number" with a format similar to this "04-1234". > When the table is opened in Excel, some of the records have their job number > treated as a date, which isn't what we want. I've tried putting a single > quote in front of the job number (the Excel trick to indicate text only), but > the quote is visible in the resulting file. Thus far the only solution we > can see is to make the job number an obvious non-number by placing a > meaningless character (we're using a period for now) in the string somewhere. > This still isn't the best solution, so now I'm looking for other ideas. > > (NOTE, this is on a CF5 server, but I don't think that is too much of a > factor). > > Thanks in advance for any tips. > > Shawn > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189414 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
