Quote:
Originally Posted by macropod
Another simple solution that requires no formula is to:
1. Type 1 into any cell
2. Copy/Cut the number to the clipboard
3. Select the range to convert
4. Use Paste Special>Values>Multiply.
|
This doesn't work, when the string isn't alfanumeric string for user's current regional settings (in OP's case, I suspect not either "$", nor "." don't allow this conversion to work)!