Format of a text variable- Output to ExcelHi all, I have a

liizz

Hi all,

I have a report which has a print to Excel functionality. I have a column which is of type text but the text is too long and it is not displaying well.

The output is as such:

35686E+14
and I have used the function FORMAT..

Please help if there are some built-in functions to display the text correctly.

I have also tried the AutoFit functionality mention on:
http://dynamicsuser.net/forums/p/51484/ ... spx#266312

Also, I tried this out: xlWorksheet.Range('A'+ FORMAT(intRowNo)).Value :=FORMAT(myvalue);

I have also placed this near ''' + 'FORMAT(myvalue) but it is not working.

But still not solved my problem.

Thanks

Liizz

mohana_cse06

liizz wrote:

I have also placed this near ''' + 'FORMAT(myvalue) but it is not working.

What is the output with this?

the above statement should be like

''' + FORMAT(myvalue)

Savatage

this is the kind of output we had on our upc codes when exporting to excel.

It's the 'ol 4 single quotes that work

EnterCell(Row, 2, ''''+Item."Item UPC/EAN Number", FALSE, FALSE, FALSE);

Your code has 3 try 4.

liizz

I have placed a ''''+FORMAT(myValue).

xlWorksheet.Range('A'+ FORMAT(intRowNo)).Value :=''''+FORMAT(myValue);

But on the cell, a '(single quote is being displayed as well)

The value is as follows: '3595704000203

How to truncate it?

Thanks
Liizz

mohana_cse06

yes, the ' will format the number to text in excel..this way we will show the full integer value in excel...