Text changes to General

G

Guest

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 ?
 
B

Bob I

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel file with olap cube gets corrupted 1
Filter list not correctly refreshed 3
Undo "Convert to formulas" pivot function 1
Pivot table layout that popluates the row label in each row? 3
Excel 2003 SP3 - can't find the .cub files 2
OLAP sum function 2
ODC properties: OLAP Server Formatting 0
OLAP Pivot Table - HT Find source data 1

Top