How can I convert a number that is text into a number? The decimal number could have one or two spaces after the whole number. For example 123 10. I would like 123.10. Text that has 0 decimal points like 456 would be 456.00. I think once I can convert the text to numbers I can then format the cell.
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Text | What I like | ||
2 | 456 23 | 456.23 | ||
3 | 789 57 | 789.57 | ||
4 | 10000 23 | 10,000.23 | ||
5 | 812 | 812.00 | ||
6 | 1000 58 | 1,000.58 | ||
Sheet2 |