converting Euro currency formatting to US currency formatting

Hi KDG,

Welcome to the forum

Not sure whether it is your system setting or cell formatting.

May be you might have assigned comma as decimal seperator and the dot as currency separator in your OS setting

hi KDG, welcome officially to the forum~ i'm a little confused though. you mentioned:

value has a comma for the thousand seperator and a decimal point for the cents seperator

but you want it:

need to make it read "1,500.22"

so data is what you want, isn't it? but if data is showing "1.500,22" & assuming it's in A1, then maybe:
=SUBSTITUTE(SUBSTITUTE(A1,".",""),",",".")+0
copy all the way down & format cells to whatever format you desire with thousand separators & 2 decimal places

if it's what Sixthsense mentioned, you should see your data aligned to the right by default. that means Excel treats it as a real number. if it's text, it will be aligned to the left. so you have to apply my formula.