|
Yes, this does not remove leading zeros and the original problem is stated as "numeric fields not zero suppressing". I read that to mean that zero suppression was desired. Yeah, I know, "not" logic is hard to wrap ones head around. :) <snip> multiple formatting issues occur...#'s representing some date fields, numeric fields not zero suppressing, columns showing as truncated although when you click on them the data is fine and other stuff of this ilk. </snip> > ------------------------------ > > message: 3 > date: Tue, 10 Feb 2004 09:53:19 -0800 (PST) > from: Scott Mildenberger <scottmildenberger@xxxxxxxxx> > subject: RE: Formatting an EXCEL Worksheet Generated From The 400 > > This doesn't solve the original problem if I read things > correctly. If the value of a character field is 00255 Excel > will still interpret this as a number and lose the leading > zeros. I checked this by using the html below and changing B > Widget's value to 00255. Am I missing something? > > Scott Mildenberger
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.