Thread: Rounding problem (controlling word from excel)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
robert burger robert burger is offline
external usenet poster
  
Posts: 25
Default Rounding problem (controlling word from excel)
Good morning,

having a problem with rounding errors when using Walkenbach Sub
MakeMemos()
how do i stop word from rounding the number from excel?
for example:
.TypeText Text:="Fee to be Deducted from Account:" & vbTab & vbTab &
vbTab & vbTab & vbTab & vbTab & vbTab & Format(Fee_deducted, "$##.##0")

number shows as 1865.000 when it should be 1864.96

Thanks,
For your help
RTB


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