I am trying to clean up data for numbers that are formatted wrong. For example, the first number has [image]. The last [image] is the decimal point. The other [image] I don't need.
Some of the other numbers are formatted as text. Also I need the decimal point inserted in the number for example for the last two rows.
Some of the other numbers are formatted as text. Also I need the decimal point inserted in the number for example for the last two rows.
Book4 | ||||
---|---|---|---|---|
A | B | |||
1 | Column 1 | What I like | ||
2 | 21[image]078[image]47 | 21,078.47 | ||
3 | 178[image]40 | 178.40 | ||
4 | 287.44 | 287.44 | ||
5 | 516 | 516.00 | ||
6 | 516.00 | 516.00 | ||
7 | 516[image]00 | 516.00 | ||
8 | 28.56 | 28.56 | ||
9 | 15865 | 158.65 | ||
10 | 246812 | 2,468.12 | ||
Sheet1 |