Tom,
bear w/ me.
here's part of my code. Somehow i don't think its right. If i declare
it as a currency then why am i giving the format as "$##.##0"

Dim fee_deducted As Currency

' assign current data to variables
fee_deducted = Format(Value.Offset(i - 1, 7).Value, "$##.##0")

' send commands to word
.TypeText Text:="Fee to be Deducted from Account:" & vbTab & vbTab &
vbTab & vbTab & vbTab & vbTab & vbTab & Format(fee_deducted, "$##.##0")

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!