I hope I can explain this properly. I have a data file that has text entered as "amount" column (M in the example below). The results I need are column L to break down the cents (which I can simply use a =right(2,0) formula). The question I have, then, is column K. How can I extract the "Dollars" as the text without rounding up or down? In particular, please note the second line of data - we need $360 (and not $361 via round function). Any ideas on a formula I can use for column K?