bgbbusk Posted December 29, 2016 Share Posted December 29, 2016 Hi, Can anybody help with this? I'm doing a product export list to count products for the accounting. How can I change the dot to a comma in the Base price when exporting to excel? Thanks Bjorn Link to comment Share on other sites More sharing options...
Daresh Posted December 29, 2016 Share Posted December 29, 2016 When exporting you can't. But when importing the file in Excel you can set decimal delimiter. Link to comment Share on other sites More sharing options...
bgbbusk Posted December 29, 2016 Author Share Posted December 29, 2016 Aha, of course ... Thanks for the tip, I will try to see if I find out how Thank you Darech 1 Link to comment Share on other sites More sharing options...
bgbbusk Posted December 29, 2016 Author Share Posted December 29, 2016 It seems like the cell is locked somehow when exported. The decimal delimiter is in fact set to comma, and I have tried a lot of variations with this. I can set it manually, and add a formula =cell1* cell2, and it's working, but to change the hole collumn is not working.... Hmm Link to comment Share on other sites More sharing options...
Daresh Posted December 29, 2016 Share Posted December 29, 2016 But it's a simple CSV file, nothing to lock there. Link to comment Share on other sites More sharing options...
bgbbusk Posted December 29, 2016 Author Share Posted December 29, 2016 Sorry, My thinking was wrong, I changed the standard from comma to dot and could add a formula to the cells Thank you for your help. Bjorn Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now