Wrong format

[#1]

Hello,

I am trying to bring a field into QV but instead of bringing me the values, it transforms half of them into numbers(or date). Here is what I mean:

How can I keep the format on the left?

Thank you

[alexandros17]

Are you reading from xls file? can you provide it?

[#3]

I am reading the data from a .dbf file (fox). I cannot copy or even access it outside of QV. The data should all be the same, but I cannot vouch for it. I will try to get some rights to access the database tomorrow . I think I will repost then. Thank you anyway for your help.

[Gysbert_Wassenaar · Accepted solution]

Change the alignment on the Presentation tab of the object properties. Or in the script use the text() function to load the field as text:

Load

text(MyField) as MyField

from ...somewhere...;