<div>
Have you tried<br />
<br />

<pre><code id="code-20-41803766-1">tbl.cell(2,9).range.text= &quot;$&quot; &amp; FormatNumber(myval)</code></pre>
</div>


Have you tried



tbl.cell(2,9).range.text= "$" & FormatNumber(myval)

<div>
No, I will try it.<br />
Will it make the $ flush left and the FormatNumber(myval) flush right?<br />
I think I need something in between that will do that.
</div>


No, I will try it.
Will it make the $ flush left and the FormatNumber(myval) flush right?
I think I need something in between that will do that.

<div>
May be if I can inject a tab? &nbsp;But how?<br />
<a href="http://www.screencast.com/t/0Awum4A0TW" rel="ugc">http://www.screencast.com/t/0Awum4A0TW</a>
</div>


May be if I can inject a tab?  But how?
http://www.screencast.com/t/0Awum4A0TW [http://www.screencast.com/t/0Awum4A0TW]

<div>
Have you tried something like this?<br />

<pre><code id="code-20-41803792-1">tbl.cell(2, 9).Range.Text = FormatCurrency(myval)</code></pre>
</div>


Have you tried something like this?


tbl.cell(2, 9).Range.Text = FormatCurrency(myval)

<div>
FormatCurrency would work if I could make the $ flush left and the number flush right.
</div>


FormatCurrency would work if I could make the $ flush left and the number flush right.

<div>
You both rock. &nbsp;I was stuck on this and your help really made a difference!
</div>


You both rock.  I was stuck on this and your help really made a difference!

<div>
<div class="content wysiwyg-content">
How can I change this code so that ther is a flush left $ sign in the table cell as in the screenshot:<br />
<br />
dim myval<br />
myval = 19298888<br />
tbl.cell(2,9).range.text= FormatNumber(myval)<br />
<br />
Screenshot: <a href="http://www.screencast.com/t/te3vRJMd0" rel="ugc">http://www.screencast.com/t/te3vRJMd0</a>
</div>
</div>


How can I change this code so that ther is a flush left $ sign in the table cell as in the screenshot:

dim myval
myval = 19298888
tbl.cell(2,9).range.text= FormatNumber(myval)

Screenshot: http://www.screencast.com/t/te3vRJMd0

vb script microsoft word table cell: inject flush left dollar sign

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.