I am wondering if there is a way to adjust my export of data in a Excel file. When I export data, it seems to come out in text format with several decimals to the right. I would like to know how to change the export to number with only two decimals to the right. On a side subject, we are now using Office 2013, I use to right click the worksheet tab, click select all, then from worksheet 1, highlight all the dimensional data, click the drop down arrow and select number formatted to have no commas. All the worksheets after 1 would than change. Now, I must do each worksheet, changing the format to number via a small window next to the highlighted info, than changing the number format to remove all the commas. Excel 2009 did all the changes on the first worksheet, this is what I would like to do, once, that's it. Does DP+ have the ability to adjust the outgoing format the way I would like it, number format with no comma? Hexagon, any thought?
Odda
