Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make my table export to excel as number ?

Hi All

I have a table , when i export to excel , excel treat my field as text , because my label is text field . even if i change my label from Unit Price to 1 , it still treat it as text.

Hope some one can share with me how to make it export as number ?

in my next post i will send a simple Doc

Paul

12 Replies
Not applicable
Author

Hi All

Enclosed my QV doc

Not applicable
Author

Hey paul,

we will get the '1' number not the text when export to excel.

Share your qvw where your not getting.

Regrads,

Rajesh.

Sokkorn
Master
Master

Hi Paul,

Are you refer to align label?

Untitled.png

Regards,

Sokkorn

Not applicable
Author

Hi Sir


See the below image . How to make the Unit Price as number ?

label become number.png

Not applicable
Author

Hi,

As per the shared image, the data under UnitPrice is right aligned which means it is in number format.

Can u please elaborate ur issue??

-Shruti

nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi,

Its displaying as text but if you try to sum up all the values then it will give you the exact sum.

morel : the column in the text format is not affecting your numbers populated in the column.

and can you please share why you want to display the Unit Price field in the Number format.

-Nilesh

Not applicable
Author

Hi Sir

From the image I posted . You can see that excel indicated the label is text.  I need it display as number. As my other software want to read as number.

Sent from Samsung Mobile

Sokkorn
Master
Master

Hi Paul,

What number you trying to display in first column?

Regards,

Sokkorn

Not applicable
Author

Hi Sir

Can  be any number. As long as it is not string.

Now after export I need to manually to to excel Chamge the unit price from text to number.

Paul

Sent from Samsung Mobile