Thread: [Solved] Convert text to number help
View Single Post
 
Old 01-04-2023, 11:28 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by macropod View Post
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)!
Reply With Quote