Thread: Format Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Always Learning Always Learning is offline
external usenet poster
 
Posts: 25
Default Format Question

Hi Guys,



I may not have explained myself properly yesterday so I am re-posting hoping
this time I have explained a little better.



Can someone tell me why?



I have a form called "ResultsForm"

On that form I have a label called "SRWValueCalculated"

In my code I have "Dim TotalCost As Currency" which gets its value using
this bit of code:

"TotalCost = TotalCost + Cost4GoodRecs + Cost4BadRecs + Cost4DOBRecs"



The variables above, Cost4GoodRecs, Cost4BadRecs, Cost4DOBRecs are all
dimensioned as Currency



If I format the label Like so:

ResultsForm.SRWValueCalculated = Format(TotalCost, "###,##0.00")

If the value of TotalCost is 5,241.60 it displays as 5,241.60 which is fine,
but, if the value of TotalCost is 10,483.20 it

displays as 10,483.2 missing the final 0 (zero)



What is wrong?



As always, your help is appreciated.



Best Regards,



Steve.