New
#1
Number data in 10 columns and 25 rows pasted from other source is text
..... and I want to convert the lot to 2 decimal place numbers.
Excel has several methods, but none seem to work for conversion in bulk. Working on futher cells from a suitably formatted one does not work.
Is the only way to solve my problem to manually enter the numbers elsewhere, clear the original cells, and then cut and paste back to the original cells?
Help please!