I need to write a formula which will take only dollar amounts from one column that contains different values including dates and put the dollar amounts into a different column say columb B. How would I do that? Macro or an IF statement... no clue --> please help anyone! THANK YOU! HAPPY NEW YEAR!