Formatting/Formula Help

Hi

I need some assistance if possible with an issue I am having.

I sell on Amazon across various markets. Initially, uploading our GBP stock and price file would then automatically populate our European stores with the correct 'converted' sell pricing. However, it now doesn't do that. Amazon have said I need to upload the price file now with the Euro price, which I thought would be quite simple, but I am struggling!

If I Insert a columm next to my UK sell price, and simply =SUM(D5*1.15) - it will give me a 'Euro' price, but in the UK format.

For example cell D5 = 110.69
E2 then shows a cell of 127.29

However, for it to upload to Amazon correctly, it needs to be in a Euro format - therefore needs to be 127,29. However, it changes the '.' in the formula to a ',' which then changes the cell result. If I keep the cell at 127.29, and then Copy and Paste values only to another column, and then attempt to change the full stop for a comma, it changes it to 1,272,912. Whatever I do in terms of formatting, with decimal placings etc. does not get it to how I need it to appear.

Any suggestions?

Hi,

Technically, you can copy your data into another sheet, format it all as "general" and then use the find/replace function. (CTL + F) Hopefully, this solves your problem.
If not, I have had a similar issue and couldn't find a suitable solution. I finally had to install VMWare and install a new opperating system in the correct language.
Best of luck!

Can you upload a sample file?