G
Guest
Hi
I have a variably sized range with numbers in text format.
I want to select them, and convert to numbers.
Thanks
I have a variably sized range with numbers in text format.
I want to select them, and convert to numbers.
Thanks
I want to select them, and convert to numbers.
Rick Rothstein (MVP - VB) said:Are you needing this in (macro) code or do you just have a range of data
that you need to convert one time? If the latter, just enter 1 into a cell
(as a number), press Ctrl+C, select your range of cells that have the
text-numbers in it, click Edit/PasteSpecial in Excel's menu, select Multiply
from the Operation section of the dialog box that appears and then click OK.
Rick
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.