numeric转换varchar,从varchar转换为decimal或numeric

hello , i have a problem dealing with convertion

so i have a column that contain amount  with type varchar ( because i extract it from an excal so i came with varchar type )

example 234,32 / -6 / 1,234,213 so i have a problem when i try to convert it in decimal number  i first treat the null value by using this expression

replace(REPLACE(ISNULL([CA CIF Net]) || [CA CIF Net] == "" ?"0" : [CA CIF Net]," ","")

and after that i made a convertion using derived column

but i doesn't work it gave me for example 23432

i think that number like this one1,234,213  causes me problem

any idea please

thank you

解决方案For 234,32 / -6 / 1,234,213  what is desired output?