Hi. Has anyone every encountered this problem: You receive an Excel spreadsheet that has all the cells formatted as GENERAL. The cells contain numbers, but the format of those number values is not really NUMBER. Therefore, these values fail to calculate in mathematical and lookup formulas. So to fix it, you have to place your cursor in the cell and click ENTER in order to refresh the cell. Then, the format of the value within the cell converts to NUMBER, and your formulas start to work.
Please see my attached spreadsheet. Is there a macro that can convert the values in column A to DATE, and the values in column B to NUMBER?
I know of a trick using the COPY PASTE SPECIAL VALUES - MULTIPLY by 1.0 method, but I was wondering if the process could be more automated with a macro.
Any advise is greatly appreciated.
Bookmarks