Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ipauldur
Creator
Creator

Text field changing to date format in excel

Hi All,

I have the field name called "UnitNo" which contains the value like "B1-02", "10-01","10-02", etc..

I want to copy the report (Full table) and paste into excel. No need to do "Send to excel".

When i copy and paste into excel, the "Unit_no" column values changing into "d-mmm" format if there is no alphabets.

For example, the value "10-02", when i paste into excel became "2-oct".But if the value "10-02A" when i paste into excel still same "10-02A".

Can you please let me know how to format or any setting can be done for geting the same data in excel when we do copy & paste.

I am using Qv10 Sr3 and MS Excel 2007 version.

I attached the sample file for your reference.

Thanks,

Durai.

11 Replies
Anonymous
Not applicable

Hi

     Please check this

     Add one single quote before the unit no and copy paste to excel

     Check wheter you have the same problem

=chr(39)&text(Unit_No)

Use this expression to check

Regards

Ashok

ipauldur
Creator
Creator
Author

Hi,

I tried this. But didn't worked. It's working only when we add any character before or after the value.

Thanks,

Durai.