how to globally replace two values at the same time in Excel

[Guest]

Hi I am importing data that has monetary values in it. when it is imported it
shows as

1.125.124,00 the number it actually should be is 1,125,124.00.

Is there a function or macro I can run to convert the first number into the
second number?

I've tried using replace ie if I replace the ',' with '.' but this ten gives
me 1.125.124.00 which is also problemmatic, any help would be greatly
appreciated

 

[David Biddulph]

Hi I am importing data that has monetary values in it. when it is imported
it
shows as

1.125.124,00 the number it actually should be is 1,125,124.00.

Is there a function or macro I can run to convert the first number into
the
second number?

I've tried using replace ie if I replace the ',' with '.' but this ten
gives
me 1.125.124.00 which is also problemmatic, any help would be greatly
appreciated

Check your Regional Options in Windows Control Panel, rather than an Excel
setting.

 

[Guest]

Hi David

My setting are all ok, the data I am importing is sent to me in a set format
so all I can do is play with the data I have.

Thanks
Lee

 

[David Biddulph]

Hi David

My setting are all ok, the data I am importing is sent to me in a set
format
so all I can do is play with the data I have.

Thanks
Lee

So are you saying that if you set the separator in regional options to full
stop and the decimal point to comma, you still can't import the data with
Excel? It works for me. You can, of course, put your regional options back
to normal after you've done the import.