Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi All
Enclosed my QV doc
Hey paul,
we will get the '1' number not the text when export to excel.
Share your qvw where your not getting.
Regrads,
Rajesh.
Hi Paul,
Are you refer to align label?
Regards,
Sokkorn
Hi Sir
See the below image . How to make the Unit Price as number ?
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
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
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
Hi Paul,
What number you trying to display in first column?
Regards,
Sokkorn
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