Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Send to Excel a table Numerical Field

Hello

i have this issue...

in some excel document when i do the "send to excel" option

it export a numerical field and the 0 of the left dissapears on excel 2007 (notepad include the 0 for verification)

but when i use the option export i choose the excel fomat then all the numbers of the field included the 0.

2 Replies
m_woolf
Master II
Master II

Field is interpreted by Excel as a value, which loses the leading 0.

You may be able to format the field as text in Qlikview and have Excel interpret as text when sent to Excel.

Not applicable
Author

Thanks

then when i do a selection export wirh the 0 ...

sometimes do it and sometime dont