Text field changing to date format in excel

[ipauldur]

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.

[Anonymous]

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]

Hi,

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

Thanks,

Durai.