Export excel in text format

[Somasundaram]

Hi Qlikers,

I am trying to export the values like 1-2,2-3,3-4,4-5 as excel file. But, I am getting the values as 1-Feb,2-Mar,3-Apr,4-May

I have tried in script, text(field) and changed the values 1*2,2*3,3*4,4*5 and replace the * as '-'. text(replace(field),'*','-') but, I am getting the same.

help would be appreciated. 

Thanks,

Somasundaram 

[Anil_Babu_Samineni]

Please check, If any custom format cell applied in Excel?

[Somasundaram]

Hi,

Yes. Custom format is applied.

[karthikoffi27se]

Hi Soma,

Please refer the below link and try any one of the options mentioned below.

https://support.office.com/en-us/article/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-...

Many Thanks

Karthik