I have not had any luck formatting a number entered to a
worksheet by a procedure so that it appears in Accounting
rather than Currency format. If the cell width is large
enough, they do appear differently when using the cell
format feature manually. I have tried: format
(thenumber,"$* ###,###.##") and (thenumber,"$###,###.##")
without success. Any ideas?