On 08/05/2013 18:11, George Gallen wrote:
That's assuming you are the one who created / imported the data into Excel.
However, I receive Excel files very frequently where the user who created it
Has little knowledge of formatting cells.
So very often I am forced to import data with dropped trailing zeros.
That and phone numbers being converted to E notation....Hate those.
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
