Formatting to 2 Decimal Spaces

So I feel like this should be simple and I've tried multiple different ways of doing this but when I save the information in a text file it still pulls all of the numbers to the right of the decimal place even though it only shows 2 numbers to the right in excel. And the Round function in VBA isn't doing anything it just exits my code or does nothing.

So I've tried this

Please Login or Register  to view this content.

as well as

Please Login or Register  to view this content.

and this

Please Login or Register  to view this content.

it will show in the cell the number as 389.69 but when you click on it is still has every number beyond the decimal point 389.694864815648946. Does anyone know what I'm missing or is excel not capable of this? Thank you

389.694864815648946.
is the mathematical value stored in a number. Try in a calculator, you get the same result

Not to be rude, but yes AB33, I understand how the calculation works, but I don't want it to round.

Thank you alansidman, the special paste crossed my mind at one point but left just as fast from frustration prbably.

TMShucks, it's just exiting my code when I do that. There aren't any formulas in that cell because I'm having the code loop through an array to put the values in those cells...would that matter?

*want it to round...for some reason the edit post isn't letting me actually edit.

Please Login or Register  to view this content.

ended up working. Thanks for letting me bounce ideas off you guys.

I was trying to say the same as alansidman's, but did not put the way he did.
The underlying calculation and value will not change, the formatting will not change the underlying value, but only the presentation.