The following comments on this were sent to Microsofts Feedback Web page. As
far as I can tell that is the best you can do in reporting a bug to the giant
without ears.

Having files imported into Excel is fairly common. There are two items
related to this I have issues with and have seen many others complain about
with great passion, that call for your consideration.

Giving the €œgeneral format€� the ability to turn off or on the option for
converting suspected text to date would be heralded by many as a great
achievement by Microsoft. The headache this lack of flexibility has caused is
not limited to importing data.

Being given the ability to set the format for the default workbook would be
valuable in exchanging data with people having limited skills such as myself.
The song and dance you give about using the XL Start directory to set
defaults comes close to being fraud when it does nothing more than provide
unnecessary instructions for providing a shortcut to a workbook while not
changing any of the default workbook settings associated with opening a new
workbook within Excel that would be required for receiving data from other
programs.


Sheeloo wrote:
Ideally SAP configurator should take care of this by specifying the fields as
TEXT.

If they can provide a CSV file (you can try renaming the file you have) then
you can import them and specify the column as text.

The problem appears to be that SAP uses the default Workbook format (General)
with the spreadsheet it creates. I would love to format it as a text column,
[quoted text clipped - 14 lines]
Thanks,
Rich

--
Message posted via http://www.officekb.com