asked on
vb script microsoft word table cell: inject flush left dollar sign
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
dim myval
myval = 19298888
tbl.cell(2,9).range.text= FormatNumber(myval)
Screenshot: http://www.screencast.com/t/te3vRJMd0
VB ScriptMicrosoft Word
Last Comment
Keith McElroy
ASKER
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.
Will it make the $ flush left and the FormatNumber(myval) flush right?
I think I need something in between that will do that.
ASKER
May be if I can inject a tab? But how?
http://www.screencast.com/t/0Awum4A0TW
http://www.screencast.com/t/0Awum4A0TW
Have you tried something like this?
tbl.cell(2, 9).Range.Text = FormatCurrency(myval)
ASKER
FormatCurrency would work if I could make the $ flush left and the number flush right.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
You both rock. I was stuck on this and your help really made a difference!
Open in new window