Currency and masking numbers

How to work with numbers and currencies, and how to create live settings update on the spreadsheet based on column values.

NameSymbolOpenClose% Net% Change
13D Systems DDD15.0815.10.010.07
23MMMM178.34178.650.490.28
358.comADR WUBA30.0129.1-0.76-2.55
4500.comADR WBAI13.4813.560.10.74