Cell Format

[stormania]

Dear Excel Master

Kindly help how change every number in cell to number as a number, because cannot SUM. I am already try TRIM, VALUE, Format cell but nothing change.

Thank you

 

[pecoflyer]

This should get you started. I'm not quite sure what 4.536 stands for? Is it a decimal number ? ( I use European number formats)

 

[stormania]

This should get you started. I'm not quite sure what 4.536 stands for? Is it a decimal number ? ( I use European number formats)

Dear Pecoflyer

Thank you for formula SUBSTITUTE(SUBSTITUTE(C18;"-";0);CHAR(160);"")+0
Than i can copy paste value to get a number. Btw 4.536 its mean 4536 (four thousand five hundred thirty-six).

Thank you, my problem is solve, thank you

 

[pecoflyer]

Than i can copy paste value to get a number

I don't see why, the formula already returns a number...