Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Somasundaram
Contributor III

Export excel in text format

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 


-Somasundaram
3 Replies

Re: Export excel in text format

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Somasundaram
Contributor III

Re: Export excel in text format

Hi,

Yes. Custom format is applied.

 

 


-Somasundaram
karthikoffi27se
Contributor III

Re: Export excel in text format

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