This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
When outputting into Excel it will take the data type and render it according to your default settings within Excel. In this case, it's recognising you're outputting a numeric value and applying the numeric mask by default.
The easiest fix is to convert the number to a string before output, if that's applicable.
The other method is to update an existing Excel sheet with the new data inputting into a named range is pre-formatted. This will then paste the new numbers in whilst retaining the original format. You can then set the numeric format in Excel.
Understood. Could you try using the data cleansing tool to remove punctuation?
If that doesn't work, as this post suggests it won't, try converting it to text and then use the formula tool to convert to a value that has a specified number format (not to include commas). Then deselect the text field so you still have just one column with your value.
Actually, you can select "Microsoft Excel Legacy (*.xlsx)" on your output and select "Delete Data & Append" and it will overwrite what's there while retaining the format. You need to name the cell range in Excel and output to that named range as the sheet/range name.
This will allow you to retain the Excel format;
If this option does not appear, download the Access 2010 (32 bit) driver.