Quote:
Originally Posted by ArviLaanemets
As you want comma as decimal delimiter, I assume you use some European regional settings. So use in row 5 the formula
Code:
=1*SUBSTITUTE(SUBSTITUTE(D5;"$";"");".";",")
, and copy it down.
Edit: I see Pecoflyer adviced practically same!
|
Thank you for looking into this for me. Much appreciated.