Separate Dollar fron Cent

[WhyDNA]

I need to separate the whole dollar amount from the remain cent amount and work on both separately. Is there a formula or series of formulas to do this?

[ranman256]

dollars =left(amt, len(amt)-3)
cents = right(amt,2)

[Jonmo1]

Try these

Dollars: =INT(A1)
Cents: =MOD(A1,1)

[WhyDNA]

Thank you, Jonmo1. This works. Now, I want to accumulate the cents counter until it reaches a dollar or more, then extract the dollar again. Is there a way to set the cell containing the cents so that I can keep adding and referring to it?

[Jonmo1]

You've lost me, I have no idea what you mean by that.

Can you post a sample workbook, and show your desired results manually entered for a few rows?

[WhyDNA]

Thanks again, Jonmo1. I figured it out. It is a matter of putting up additional cells to play around with the INT and MOD formulas that you suggested. I really appreciate your input to solve my problem.

[Jonmo1]

You're welcome.