My trailing zeroes are being truncated

  • Thread starter Thread starter Walt Hoffman
  • Start date Start date
W

Walt Hoffman

we're viewing currency data in a table/query - when you
open the query itself the two #s following the decimal
are there, but when we attempt to use that data in a
document the trailing zeros disappear, e.g $21.90 becomes
$21.9.

Your assistance will be greatly appreciated
 
I believe you can set the format within Word. An alternative is to use
NumFormatted:Format([YourField],"$0.00")
or something similar that would force a text string.
 
Back
Top