Date in Perspectives

[ravikrishna23]

Hi

I have a cube1 which pulls data from a file and then User inputs/edits some data manually in Excel.
The DATE comes in the format of YYYYMMDD from the file but has to be shown in the Cube in the format MM/DD/YYYY

We used the substring to display it in the required format

Now, the issue that we are facing is that User when trying to edit the date field in Excel (perspectives) its converting automatically into DAYNO.
However I am able to enter the data directly in the MM/DD/YYYY format

How do I fix this issue in excel where the user can input the date in excel in the MM/DD/YYYY

Thanks

[rkaif]

Did you try changing the Cell format in Excel itself?

[ravikrishna23]

Yeah, I tried changing the format in excel but no use.

[Gregor Koch]

Hi
Usually adding a single quote will solve this.
So rather than entering 10/10/2010 in Excel enter '10/10/2010. The single quote won't be sent to TM1.
Cheers