Write rounded cell values in a text file

[sverker]

Hello,

I use the following expression to write Excel data in a text file.

Mid(MyStr, 14) = " EH=" & Cells(MyRow, 6).Value

If the cell contains a number with many decimals all is printed to the textfile. Is it possible to round the number before writing it to the text file?

 

[Andrew Poulsom]

Welcome to the Board.

For 2 decimal places:

Mid(MyStr, 14) = " EH=" & Format(Cells(MyRow, 6).Value, "0.00")