Yes, SAP is probably saying it would be ideal if Excel provided this feature
and there you have it, a user hostile environment where it is someone elses
and nobodys fault.

Although SAP does provide CSV as an export option I would rather not go that
route as I would have to train about 20 people on how to use it, and then it
would be clunky compared exporting directly to an Excel Pivot table as SAP
does allow.

Surely there must be some way to set the default workbook fields to something
other than a general format. As previously noted the default workbook is the
one that starts from the €œFile Menu, New€� option, not the default startup
workbook that starts when the Excel program opens.

Thanks,
Rich


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