How to Keep both Dollars and Cents in Formatted Output?

[Eternallamp]

Somehow, all of my currency outputs are being rounded to whole dollars. i suspect there is a really easy solution, if you will? I am using this simple output statement: Range("J" & index1).Value = myRpmtBal

 

[jkpieterse]

You must change the number format of the cells in question.

 

[Eternallamp]

Somehow, all of my currency outputs are being rounded to whole dollars. i suspect there is a really easy solution, if you will? I am using this simple output statement: Range("J" & index1).Value = myRpmtBal

Found it, setting the Data Type to Currency adds the precision needed.