I just figured out how to use the Text to columns feature for separating
dollars and cents into two separate columns. It works perfectly if I type the
dollar amount into the cell but if I try to use this feature on a cell that
contains a function, Text to Column sees the function instead of the dollar
amount and does not work properly.

Basically, I am trying to add up a row of dollar amounts and the total must
be displayed with the dollars in one column and the cents in another.

Any suggestions?