I have numbers in E2:E3265 that have been downloaded from a database, but they were downloaded in text format. I want to convert all of these to number format. I know you can do this by multiplying by 1. I know how to do this for a single cell, but can this be done for a range of cells w/o using a loop?
This isn't working:
Range("E2:E326").Value = Range("E2:E326").Value * 1
Bookmarks