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
... I can't be too rude though because this lady is a good friend of
and sort-of-boss-to my wife)
Cheers,
Wol
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
