VBA output - force trailing zeros

[out2thow]

Good morning everyone,

I have an excel VBA application I need some direction on.

I'm calculating values in Excel based on formulas, then printing the results to a text file.

My VBA command looks like this:

Please Login or Register  to view this content.

however, in Excel, if my formula calculates a whole number displayed as 1.000 in the cell - formatted as a number. If formatted as text it displays 1 without decimal. Regardless, the above VBA function prints X1 where I need the output to hold the decimal place. Precision isn't a concern, but holding the decimal place is.

Any help is greatly appreciated.

Thank you

[mikerickson]

Try

Please Login or Register  to view this content.

Format is the VBA equivalent of the worksheet function TEXT.

[out2thow]

that worked. Already adapted it to my VBA code!

Thanks a million!