i have a workbook that has been exported from QuickBooks and when exported it is returning column "N" as text where it should be a number. (I.E. 24.01 appears but the error button is there stating it is text and gives you the option to convert to a number). Is there a way to code a sub routine that will convert this to a number automatically and if there is a NULL cell in the same range, convert it to 0?