Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OLAP and number formatting
I am bringing in a text file to OLAP via Access. If I send the text file
directly to Excel the period number can be sorted as a number. However somewhere in the Access part I am losing this and it reformats to general, even when I specifically select number in the design. It then comes out with period 10,11 and 12 before period 2. Anyone got any ideas as to where the solution can be found. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLAP sum function | Excel Discussion (Misc queries) | |||
OLAP TABLES | Excel Discussion (Misc queries) | |||
olap cube | Excel Discussion (Misc queries) | |||
OLAP Cubes | Excel Discussion (Misc queries) | |||
OLAP for Excel | Excel Discussion (Misc queries) |