//UTF8 encoding After converting text cells to number (using: "LeftClick/Format cells...") at the begining of number there is hidden ' (apostroph) char. This char can be deleted only by editing every cell. Is it possible to remove all ' characters automatically? SOLUTION: 1. Select cells 2. LeftClick/format cells... 3. change format to number 4. menu: Edit/Find and replace 5. Set search string to: .* 6. Set replacement to: & 7. click: More options 8. check: Current selection only 9. check: Regular expressions 10. click: Replace all