how to convert an european number in an us number like 174,00 to 1

Diana · Apr 19, 2010

I would to know how to convert an european number in an us number like 174,00
to 174.00

Thanks,

Diana

Eduardo · Apr 20, 2010

Hi Diana,
in another column enter

=SUBSTITUTE(B4,",",".",1)