Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format Question | Excel Discussion (Misc queries) | |||
Yet Another Name Format Question | Excel Discussion (Misc queries) | |||
Format Question | Excel Worksheet Functions | |||
Format question | Excel Discussion (Misc queries) | |||
Format question | Excel Programming |