What about concatenating in some tab characters in?
It would not meet your need to right justify the right side of your text lines, but it could left-align the right column of your reference file, and look neater than just inserting spacing.
You can use Char(9) to render a tab.
Turns out that my first though works pretty well, at least for OS X.
Below is the basic calc I'm using.
The 1.8 constant right aligns the numbers pretty well from $0.00 though $9,999,999
"MyTitleHere: " & Right(" "; (18-Length(MyDollarValue))*1.8) & MyDollarValue
If you really need this to be precise, you can build your own layout to use as a "dialog" with text objects that use custom tab and alignment settings, then script opening to that layout in a new (modal) window. (Be sure to include a close or other control button to let the user get back out of it when done.)
This gives you absolute layout control of your content and affords other options by using buttons for any variety of user actions after viewing your "dialog" layout.
You can even employ global fields on this layout which your script sets for you, giving the layout the flexibility to be used for multiple report types.
It doesn't need to be that precise. I have a layout that mimics a standard dialog box where I have more control but it would be a fair amount of work to change over all of the simple 1 line button dialogs I have now. As you can see in the image below, it lines up pretty well.
I thank you both for your ideas, though.