[swamiji]

Hi. Using excel 2000 under Win-XP. While using my own VBA program to calculate a few simple figures and display them in a cell, I have noticed that the ROUND(x,n) function is returning 8.5 instead of 8.50, even though all appropriate fields are DIM'd as Currency.

Everything else works fine. Unfortunately, this means that I have to live with displays like this:
$45.89, $56.8,$43.09 etc. I place all the figures in the same cell, so excel puts them there as a string, which is fine. Whilst using the VB editor, I can see that it is the ROUND function (or maybe excel itself) which is truncating the trailing zero.

Other than writing a special routine to add a trailing zero, is there something else I can do?
(I am leery of using a global STYLE setting because of potential complications).

Perhaps someone knows of a better ROUND function or Sub?
I assume that this is a bug in Excel, since I can't imagine why anyone would want to show an amount with only one decimal place where a zero is involved.

PS: I realize that I could give each amount its own cell and use a format to fix it that way, but I prefer to have a series of amounts separated by commas in one cell, in this case.

Thanks.

Feel free to email me directly.

[bomb #21]

"Other than writing a special routine to add a trailing zero, is there something else I can do?"

Not sure what lengths you don't want to go to. Have you tried (e.g.):

x = Format(Round(x, n), "$0.00") & ", "

etc?

[swamiji]

Thanks Bill. I never needed to use that format command within VBA before. It works! However, at first it didn't, since I had Dimmed the fields as Currency.
Once I changed the Dim lines for the fields (your x) to Strings, then all went fine.

Thanks again.

Swamiji