Converting UK Currency to Euro format

Daithi

New Member
Joined
Feb 28, 2014
Messages
15
Hello

I posted this yesterday but I think it was in the wrong place. Sorry.

I have a worksheet where all the values are written in UK format, e.g.

10,000,000.00
7,500.12
100.00

I need to have them in Euro format, i.e.

10.000.000,00
7.500,12
100,00

The built in Currency Formatting isn't working for me. It's putting an extra 2 zeros in the value. Nor is Find/Replace.

Hope some one can help


Best

David
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Try this.

File
Options
Advanced
Untick the box for "Use system separators"
Then in the box for "decimal separator", you probably have the "." character, replace this with ","
And similarly for "thousands separator", replace "," with "."
 
Upvote 0
Gerald....Thank You!!!

Your solution works perfectly :)

I have tried to reply before but each time I tried to send I got logged out.

A small follow-up question. If there are zeros following the decimal point, in the formula bar, I don't see the zeros. But if there are numbers there I see them. I'm just curious why this is.

Best

David
 
Upvote 0
The formula bar shows the underlying value that Excel is holding, and this disregards any formating that may have been applied to the cell.

For example, if you enter the value
1
in a call, you can format this to display in the cell as
1.00
but the formula bar always just shows the
1
That's just the way Excel is, and I think knowing that can be helpful.
On this board there are quite often questions from people who are confused about why their cell is displaying a different number from what they expect, and the reason is often cell formating.
Comparing the formula bar with the cell's appearance can give you a clue to this.
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top