View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BOHICA BOHICA is offline
external usenet poster
 
Posts: 18
Default Excel Form Issues...again :)

Well hello! You people seem to have an answer for me every time, and
guess what? I GOTS ME ANUTTER!!

Here goes: I have a form that users enter information in, and on
changes to those fields, calculations are performed and results put
into text boxes on the bottom (totals and such). My issue is this: I
want the value calculated to display like money ($##.##). I have
tried setting variables as currency (didn't do nuttin) and have tried
rounding to 2 decimals (didn't do it). When the total has decimals,
it displays them, but absolutely refuses to show me the money so to
speak when it is a whole number. How the hell do I get it to show
them pesky .00's?

(Sample code)

Dim muhTotal As Currency

(also tried this with/without the following code, and the following
code with the above defined as Dim muhTotal)

muhTotal= Round(muhTotal, 2)


So...Whatcha think?