Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text date to general number | Excel Discussion (Misc queries) | |||
Strange phenomenon with General vs. Text formatting | Excel Discussion (Misc queries) | |||
Format: General - Text - General | Excel Worksheet Functions | |||
converting general text to date time | Excel Discussion (Misc queries) | |||
converting general cells format to text | Excel Discussion (Misc queries) |