Excel Buffer Cell format problem

cunny

Hey guys,

I got some excel buffer format problems here when I load the excel worksheet into NAV excel buffer table. The problem is '1123' became '1,123' in Excel buffer table but what I want is original '1123'.

I found few threads but still cant get it fixed.

Any idea

Regards,

bvbeek

Try to place an @ character in the ExcelBuffer.NumberFormat field.

Becka

Use Function FORMAT before putting the variable into the table, to format it.... See Help(F1)

cunny

Thanks guys,

I got it fixed by changing “XlWrkSht.Range(xlColID + xlRowID).Value” to “XlWrkSht.Range(xlColID + xlRowID).Text”, then i have a slight concern that the “XlWrkSht.Range(xlColID + xlRowID).Value” was originally used, since the cell value field only contains text constant why wouldn't they use “XlWrkSht.Range(xlColID + xlRowID).Text” instead, hope somebody can share the idea here. And will try the solutions provided by you guys later on.

Have a good day,