Formatting of numbers in Word 2000 VBA

[carl777]

How does one control the formatting of numbers (for displaying or printing) in Word 2000 VBA? I'm getting 14 decimal places, and only want one decimal place.
Also, how do you place more than one command on a line in Word VBA? (What's the separator/delimiter between commands?)
And lastly, does anyone know of a good source for common VBA commands and syntax? The garbage I've been able to find in Office 2000 is inapproprite and far too complex.

 

[Bowers74]

NumberToFormat = Format(NumberToFormat, "#,##0.00&quot

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[carl777]

Thank you. That did it! Can you also tell me how to put more than one command on a line? Is here a separator I can use between commands?

 

[GeekGirlau]

Carl, don't know whether this is actually possible, but even if it is it's a REALLY bad idea. Keep in mind that the life of your code is usually a lot longer than you originally anticipate. Your code needs to be easy to read not only now, but in 5 years time and by someone other than yourself.

Trying to decipher what's going on in poorly structured code is a nightmare, so always keep it simple to read, with indented lines where appropriate, comments within the code itself, and comments at the start of your code explaining the overall purpose, inputs and outputs used.