There are a couple ways to prevent automatic numeric reformatting in Excel:
1) Any value preceded by a single quote is not treated as a number and is thus not reformatted. So a telephone number becomes '123-456-7890. 2) If the document is real Excel and not just CSV rendered in the Excel application, you can format the column to be Text. This also has the advantage of avoiding a warning which may display from 'values, where Excel keeps trying to let you know that a value looks like a date or some other format. [ad] And of course all of these situations are avoidable by using NebulaXLite. http://Nebula-RnD.com/products/xlite.htm [/ad] HTH T > From: Jeff Schasny > You can create a custom format in Excel containing a zero mask of how > ever many characters you like and that will preserve (well, actually > replace the already stripped) leading zeros. > > Anthonys Lists wrote: > > With our phone numbers ... we are forced to use a database that > > exports to excel ... > > > > And if you don't put spaces and whatnot in phonenumbers to force excel > > to realise it's text, all your phone numbers have their leading zeroes > > stripped ... > > > > (I believe it's written by outside consultants, but the lady internal > > to the organisation who looks after it thinks it's wonderful. As a > > database programmer forced to use it, my opinion of it is unprintable _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
