Loading...

RE: qExcelViewer – how to convert a number column to text?

RE: qExcelViewer – how to convert a number column to text?

#7226
Anonymous
Anonymous
Participant

Hi ,

n

The same issue occurs in the Excel Export function for qListview and qSIListview web parts.  When the column contains leading zeros – for example, 012345.9999, they are treated as number instead of text, so the leading zero is dropped (i.e. 012345.9999 becomes 12345.9999).

n

Please kindly advise if there is a workaround for this issue? 

n

Thanks again!

n

n

n