Text changes to General
 

I am creating a data cube. The file has 750,000 rows. It is in Excel 7, but I
must develop a cube for Excel 2003 users. The field "Invoice To Code" needs
to be formatted as text because it has both letters and numbers in it. So it
is text in the Excel file, from which I have created the csv file, from which
I have created the OLAP cube, from which I have created the Pivot table.
However on reaching the Pivot table, all of those rows where the "Invoice to"
code has a letter in it are set as 0. Furthermore the other entries have gone
to general format.

Does anybody know how I would keep the text format throughout the process ?

Text changes to General
 

Don't know about that issue but with Excel 2003 only handling 65536 rows
going to make it a bit of an issue?

Hood wrote:

I am creating a data cube. The file has 750,000 rows. It is in Excel 7, but I
must develop a cube for Excel 2003 users. The field "Invoice To Code" needs
to be formatted as text because it has both letters and numbers in it. So it
is text in the Excel file, from which I have created the csv file, from which
I have created the OLAP cube, from which I have created the Pivot table.
However on reaching the Pivot table, all of those rows where the "Invoice to"
code has a letter in it are set as 0. Furthermore the other entries have gone
to general format.

Does anybody know how I would keep the text format throughout the process ?

Text changes to General
 

No, because by using OLAP I have already summarised the information by month.

"Bob I" wrote:

Don't know about that issue but with Excel 2003 only handling 65536 rows
going to make it a bit of an issue?

Hood wrote:

I am creating a data cube. The file has 750,000 rows. It is in Excel 7, but I
must develop a cube for Excel 2003 users. The field "Invoice To Code" needs
to be formatted as text because it has both letters and numbers in it. So it
is text in the Excel file, from which I have created the csv file, from which
I have created the OLAP cube, from which I have created the Pivot table.
However on reaching the Pivot table, all of those rows where the "Invoice to"
code has a letter in it are set as 0. Furthermore the other entries have gone
to general format.

Does anybody know how I would keep the text format throughout the process ?