Cardinal Text and Decimals

  • Thread starter Thanks for the Help
  • Start date
T

Thanks for the Help

Is there a way to make field result "10.125%" read "ten and 1/8"?

{ = { REF LegalInterestRate }*100 \*cardtext} yields, "ten"
{ = { REF LegalInterestRate }*100 \*dollartext} yields, "ten and 13/100"

Stumped.
 
G

Graham Mayor

If your merge data source is Excel (which from the use of REF fields is
probably not the case) you could format as fraction in Excel and attach the
data file as DDE to bring over the formatting from the cell.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

\* DollarText 2
Need Help With YIELDMAT 6
If Then Else 2
Excel does not accept text format! 0
Excel concatenate 1
Sum and Rank 5
DollarText Result 5
Rounding and Displaying as Text 1

Top