Number Format to General Format

[mkc80]

I am exporting data from access 2007 to Excel 2007 using VBA code. I have a whole number, which I want displayed as whole number. But after the export, the number is using the 1000's seperator in Excel. So for example if my original number in access table is 12000, it is showing up as 12,000 in the excel file.



It has something to do with the NumberFormat property. I have tried doing this but doesn't work.
objSheet.Range("A1:A7").NumberFormat = "General"

Can someone suggest the correct way of handling this?

[June7]

What do you mean 'doesn't work' - error message, nothing happens, wrong results?

I tested code in VBA behind Excel and it works so must be something about execution in Access. Post complete procedure code or provide files for analysis.

[bcmarshall]

You should be able to convert easily enough. Try this. Str([YourNumberField]). It will essentially be text at that point, like an address would be 12345 Mockingbird Lane, not 12,345 Mockingbird Lane. Also, check the cell formatting in Excel. Should be General.